using the 'LIKE %String%'in the Where clause will return true if the 'String' exist in the row being examined, regardless of the position of the 'String' in the row.<br>
For example:<br>
<br>
Select * from myTable WHERE ColumnX LIKE %ABCD%<br>
<br>
will return true if 'ABCD' was found in ColumnX.