Re: an 'ALL_FIELDS' equivalent

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1998/02/14
Message-ID: <6c4h93$jci@bgtnsc02.worldnet.att.net>#1/1

You could try the query below:

SELECT f1, f2, f3, f4, f5, f6
FROM table_1
WHERE ((f1 LIKE '%somestring%') OR (f2 LIKE '%somestring%') OR (....));

Hope this helps.

Michael Serbanescu

---

Kal Khatib wrote:
>
> I don't know if it is possible, but..
> I'm trying to translate this psuode statement into SQL
>
> select * from table_1
> where (any of the fields selected) like ('%somestring%')
>
> OR
>
> select f1,f2,f3,f4,f5,f6 from table_1
> where (any of the fields selected ) like ...etc
>
> is it possible to translate the 'any of the fields selected' to SQL?
>
> thanks for any help
> Kal.
> --
> http://members.tripod.com/~kalk
Received on Sat Feb 14 1998 - 00:00:00 CST