If either the expressionToFind or expressionToSearch expression has a Unicode data type (nchar or nvarchar), and the other expression does not, the CHARINDEX function converts that other expression to ...

What's the neater way to do this? I've got a data in a field 'foreignkey' in a particular table which is made up of various foreign keys delimited by '~' eg PLIE312~AP~347~212121~1~no I'm having ...

All the positions or offsets, returned or specified, in the CHARINDEX function are always character offsets and may be different from the byte offset for multibyte data.. If the string being searched: ...