Re: exact matching

[Gerald Clark]

Jim Burnett wrote:
> 
>  is there a way to use wild cards in a WHERE statement?
> 
> WHERE pet.name = "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 pet.name LIKE "%jim%" 

or possibly

WHERE pet.name LIKE "jim %"

you get the idea.