I have a number of columns I'm selecting from a table, and I'd like to use PATINDEX to search for a string within a field. Upon finding this string it would return another string...:
WHEN PATINDEX('%INX%',PARTNERID)>0 THEN 'AXXENT'
END AS PARTNERID
However, I'm getting this error:
Incorrect syntax near '>'.
Could someone please point me in the right direction?