Display selected Columns in Query

[Yerdon]

Hi Everyone,

This is a question that has come up for me over the years. I wonder if there is anybody out there who has come up with a way to do this?

Sometimes I don't know exactly what columns are in a table, and in order to find them I have to scroll through the whole table.

select * from mytable

It would be easier if I could do something like this:

select tmp% from mytable

This would return any columns that started with "tmp" in their name.

Any ideas?

Thank you!

Joseph

 

[philhege]

SELECT * FROM INFORMATION_SCHEMA.columns
WHERE LEFT(column_name,3) = 'tmp'
AND table_name = 'Mytable'

Read about the INFORMATION_SCHEMA views in BOL.

HTH,

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.