Re: selecting in ALL colls of a table

2003-09-14 Thread Paul DuBois
At 12:04 PM +0200 9/14/03, [EMAIL PROTECTED] wrote: I have a very strange table. Its cols are changing dynamicly. Not all cols are all the time in the list. Now I'd like to know if "something" is in any of the fields contended. I'd like to make a "SELECT * FROM table WHERE any field contains 'some

selecting in ALL colls of a table

2003-09-14 Thread moga
I have a very strange table. Its cols are changing dynamicly. Not all cols are all the time in the list. Now I'd like to know if "something" is in any of the fields contended. I'd like to make a "SELECT * FROM table WHERE any field contains 'something' " I dont wand a workaround ... I know I cou