Home Forums SQL Server 2012 SQL Server 2012 - T-SQL TSQL PatIndex RE: TSQL PatIndex

  • 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.