Question

求SQL语句，删除逗号之前的字段。

比如：jingdu字段值116.989778,35.446271。删除逗号之前的116.989778,

另外一个：weidu字段值116.989778,35.446271。删除后面的,35.446271

Answer 1

select SUBSTRING(jingdu,CHARINDEX(',',jingdu)+1,1000) as jingdu
,SUBSTRING(weidu,1,CHARINDEX(',',jingdu)-1) as weidu
from 表名

追问

#1305 - FUNCTION zcfccs.CHARINDEX does not exist