Hi,
>> I have an adress-db and I need to search within all fields with a
>> 'LIKE-search'.
>> I cannot see how to do this !? (Syntax?)
>> my adress-db is only one 'table' containing 18 fields - nothing special.
>
>IT is NOT possible search ALL fields at once.
>You need use for each field separate search.
>
what about a bunch of OR?
e.g.
Where (field1 like 'foo') or (field2 like 'foo') or (field3 like 'foo')
or...
Cool Runnings,
Erne.
©2002 erne |
