Oh gosh, it couldn't be that simple could it? I'll test it - thanks Stefan!



>>I just can't remember this, but I know I've done this before. I have a column in sqlserver which has two strings in it separated by a semicolon. I need to pull all the records where the string on the right of the semicolon in the column matches a specific value:
>>
>>Example looking for all records with 'ABC' after the semicolon in the column:
>>
>>Example record that would match: mytable.mycolumn = 'Anyvalue;ABC'
>>Example record that would match: mytable.mycolumn = 'Anyvalue; ABC'
>>Example record that would NOT match: mytable.mycolumn = 'Anyvalue' or 'Anyvalue;DEF'
>>
>>Note the third example - one record does NOT have a semicolon at all and if there is no semicolon, then there is no value to pull.
>
>
>Would 'Anyvalue; morechars ABC' be a valid value too?
>

>Select * From myTable Where myColumn Like '%;%ABC%'
>

>
>
>
>hth
>-Stefan