Query where field contains *

[flaviooooo]

Hey,

I'm having trouble with this seamingly easy task.

I would need to create a query that looks in a field if it contains a star (*)

Unfortunately, whenever I create the where-clause to look like "*", it gives me all the records

Can someone point me in the right direction?

Thanks in advance

 

[PHV]

Like '*[*]*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[flaviooooo]

Very nice, thanks!