Re: selects with wildcards for field/column names

2004-07-30 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Jason Joines <[EMAIL PROTECTED]> writes: > Is it possible to use a wildcard for field names in a select? Nope. > For instance if I have a table with a hundred columns... ... then you have probably a broken DB design. What are you trying to do? --

Re: selects with wildcards for field/column names

2004-07-30 Thread gerald_clark
Jason Joines wrote: Is it possible to use a wildcard for field names in a select? No. For instance if I have a table with a hundred columns and I want to retrieve all rows who have a certain value in any column but don't want to type in a hundred column names in my query, how do I do it?