Query entire Description for a value of FAX

[IndyCoder]

I have been asked to query our DB for all product descriptions that have the word fax in them. This field is a 255 character field and I am not sure where to start.

I know if it was a field with just fax I could pull use the criteria of = "FAX" to get this but it is a little more complicated.

Any help would be appreciated
Thanks

 

[cranebill]

where StrConv (yourfield, 1)Like '*FAX*'

the strConv changes your field to all uppercase so you will find the word 'fax' no matter what case it is in this way.

 

[PHV]

In the criteria cell: Like '*fax*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Melagan]

I don't think JetSQL is case sensitive when using wildcards.

~Melagan
______
"It's never too late to become what you might have been.