27,579
社区成员
发帖
与我相关
我的任务
分享
create table tb(jldw nvarchar(20))
insert into tb select '0.4-4.6 pg/mL'
insert into tb select '<125 pg/mL'
insert into tb select '<15 ??ol/L'
insert into tb select '0.8-2.0 ng/mL'
insert into tb select '5.1-14.1 ??/dL'
insert into tb select '2.0-4.4 pg/mL'
insert into tb select '0.93-1.7 ng/dL'
insert into tb select '0.27-4.2 ??U/mL'
insert into tb select '98 - 107 mmol/L'
insert into tb select '22 - 29 mmol/L'
insert into tb select '60-117 mg/dL-females'
insert into tb select '66-133 mg/dL males'
go
select distinct * from(
select right(jldw,charindex(' ',REVERSE(jldw))-1)jldw from tb
)t where charindex('?',jldw)=0 and charindex('-',jldw)=0 and charindex('/',jldw)>0
/*
jldw
--------------------
mmol/L
ng/dL
ng/mL
pg/mL
(4 行受影响)
*/
go
drop table tb
create table tb(jldw nvarchar(20))
insert into tb select '0.4-4.6 pg/mL'
insert into tb select '<125 pg/mL'
insert into tb select '<15 ??ol/L'
insert into tb select '0.8-2.0 ng/mL'
insert into tb select '5.1-14.1 ??/dL'
insert into tb select '2.0-4.4 pg/mL'
insert into tb select '0.93-1.7 ng/dL'
insert into tb select '0.27-4.2 ??U/mL'
insert into tb select '98 - 107 mmol/L'
insert into tb select '22 - 29 mmol/L'
insert into tb select '60-117 mg/dL-females'
insert into tb select '66-133 mg/dL males'
go
select distinct * from(
select right(jldw,charindex(' ',REVERSE(jldw))-1)jldw from tb
)t where charindex('?',jldw)=0 and charindex('-',jldw)=0
/*
jldw
--------------------
males
mmol/L
ng/dL
ng/mL
pg/mL
(5 行受影响)
*/
go
drop table tb