Joe Grech wrote:
Hi, does the wild card work in queries? Cos I am not getting any results.
Single items are displayed but not a whole list.
Tks
It depends on whether you're using the GUI or SQL (the GUI uses * and
SQL uses %). But for instance in the GUI, to have the query return all
the records with the word "check" in a field somewhere, maybe with other
characters before and after, you would use the condition LIKE '*check*'
-- note the wildcard at each end. Without the leading one, the record
would not be found unless the field began with that word. I'm not sure
the trailing one is necessary, but it doesn't hurt.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
