Simple query help

[ptrifile]

I have a very basic table with only one field and I just need to know the syntax for returning records that contain the word "HIPAA" anywhere in the field. So if something says "XXX HIPPA XXX" or "HIPPA XXX XXX" that those records are shown. Any help is appreciated

Thanks

Paul

 

[Golom]

SELECT fld From tbl

WHERE fld LIKE '*HIPPA*'

You will need to use '%HIPPA%' if you are using ADO.