先找出第二个*的位置:
x=CHARINDEX('*', fld, CHARINDEX('*', fld) + 1)
然后用:
substring(fld,1,x)和substring(fld,x,1000)
x=CHARINDEX('*', fld, CHARINDEX('*', fld) + 1)
然后用:
substring(fld,1,x)和substring(fld,x,1000)
select * from yourtbl order by
SUBSTRING(fld, CHARINDEX('*',fld,CHARINDEX('*',fld)+1) + 1, 1000),
SUBSTRING(fld, 1, CHARINDEX('*',fld, CHARINDEX('*', fld) + 1) - 1)
left(field1,len(field1)-CHARINDEX('*',reverse(field1)))
后半部分
right(field1,CHARINDEX('*',reverse(field1)))