select substring(column,1,charindex('.',column)) from table
left('abc.000',charindex('.','abc.000')-1)
declare @v varchar(20) set @v='abc.12' select substring(@v,1,patindex('%[^a-z][^A-z]%',@v)-1)-------------------- abc
Create table ta (a varchar(20)) insert into ta values('abc.000') select substring(a,1,charindex('.',a)) from ta '结果'abc. select substring(a,1,charindex('.',a)-1) from ta abc
select substring(column,1,charindex('.',column)) from table
declare @v varchar(20)
set @v='abc.12'
select substring(@v,1,patindex('%[^a-z][^A-z]%',@v)-1)--------------------
abc
insert into ta values('abc.000')
select substring(a,1,charindex('.',a)) from ta
'结果'abc.
select substring(a,1,charindex('.',a)-1) from ta
abc
set @s='abc.000'
select parsename(@s,2)/*
--------------------
abc
*/
查一下用法