RE: SQL wildcard search

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: David Bocian
> 
> I am trying to find all records in a file where FLDA contains an
> underscore ('_').  Here is my select statement:
> 
> SELECT * FROM FILEA WHERE FLDA LIKE '%_%'
> 
> Unfortunately, it returns every record in the file - and none of them
> have an underscore in the field.

Underscore is equivalent to "match any single character".  To get around
it, you have to "escape" the underscore:

WHERE FLDA LIKE '%\_%' ESCAPE '\'

This sets the backslash to be the escape character.  Then, in the search
string, the backslash negates the wildcard property of the underscore,
making it just another letter.

Joe