Search results for query: *

Hi Sunil, Wow, yes that works! I can tweak this for the other DBs if I can find an equivalent for INFORMATION_SCHEMA. Thanks very much. And thank you to all for your help. Bill

Ifcfan, thanks very much. That is a time saver. I'll remember that for the future. Bill

Thank you, fluteplr. I did read your post and I appreciate it. However, in creating a view I'm still required to list(type) the columns that I do want. Essentially, doing a SELECT on the original table in order to create the view. The question came up recently as to whether or not it's...

Woops, I spoke too soon. Unless I've misunderstood plantj's script I believe this will return the records of all the fields(columns) except those records where o.name is "mumble". However, it will still include ALL of the columns (32 in syscolumns) in the return results. I'm sorry if...

Woohoo! yes, that did. Thanks very much plantj. And thank you to everyone who took the time to respond.

1. Suppose you have a table with 100 fields. 2. You don't want to alter the table in any way. 3. You want to select everything from all fields except one. 4. You don't want to type a SELECT statement naming the 99 fields you do want. Can this be done using a SQL statement? Thanks for any...