sql截取最后一个~~前的字符

select reverse(substring(reverse(count_no),CHARINDEX('',reverse(count_no))+2 ,LEN(count_no) )) from [dbo].[File_Title] where count_no='188文书档案2045综合档案室长期000001~~8.94019'

推荐阅读更多精彩内容