You can use LIKE operator, the same as in VFP

SELECT * FROM Mytable WHERE Mycolumn LIKE '%;%ABC'

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