[color=green]USE pubs
GO
SELECT CHARINDEX('wonderful', notes)
FROM titles
WHERE title_id = 'TC3218'
GO
///wonderful is text infomation
/// notes is colmun information
///return worderful is position [/color]
相关资源：sqlserver 中charindex/patindex/like 的比较
