List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 25 1999 4:07pm
Subject:Re: exact matching
View as plain text  
Jim Burnett wrote:
>  is there a way to use wild cards in a WHERE statement?
> WHERE = "jim "
> right now i can only use WHERE if i have an exact match, If I am searching a large
> table, can I use WHERE with just part of that data in a specified field? That way it will
> list every record with the word 'jim' it  then group it by a speceified name.
> -jim-
WHERE LIKE "%jim%" 

or possibly

WHERE LIKE "jim %"

you get the idea.
exact matchingJim Burnett25 Jun
  • Re: exact matchingGerald Clark25 Jun