Query to Show Fields with particular content

[matthoward]

I am looking for a query which most people probably no the answer to but I am having a mental block on. I need to be able to run the query so it will bring up all records with the name "Trust" in the field. The other question is how do I do a query to exclude certain records that contain a particular field as I now how to include to certain records which contain content not vice versa. For example
A table which has product type. contains fields atn, atx, atw, btw, bcw, zzz, ttt, def,
I need to find a way to not display btw and bcw fields.

Cheers and thanks heaps in advance Matt

 

[r937]

>> I need to be able to run the query so it will
>> bring up all records with the name "Trust" in the field

select foo, bar, qux
from yourtable
where thefield like '*Trust*'

>> I need to find a way to not display btw and bcw fields.

select foo, bar, qux
from yourtable
where thefield not in ('btw','bcw')


rudy

 

[matthoward]

Wat is "select foo, bar, qux", Sorry for sounding dumb,

Cheers Matt

 

[r937]

those are metasyntactic variables

http://www.catb.org/~esr/jargon/html/M/metasyntactic-variable.html