Home Forums SQL Server 2012 SQL Server 2012 - T-SQL TSQL PatIndex RE: TSQL PatIndex
David Burrows
SSC Guru
Points: 65138
More actions
July 17, 2015 at 6:16 am
#1813250
PATINDEX('% [2] %', ' ' + Marketing_Special_Attributes + ' ')
will give you char position in the string
or zero if not found
Far away is close at hand in the images of elsewhere.Anon.