![]() *, substring(img, starts, case when pos > 0 then pos - starts else len(img) end) token Select img, pos + 1, charindex('_', img, pos + 1) ![]() Select img, 1, charindex('_', img) from #t Select pos + 1, charindex('_', img, pos + 1), img Select 0 as row, charindex('_', img) pos, img from #T One way (2k8) select 'abc_1_2_3_4.gif ' as img into #T
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |