MS SQL problem

Customer Support Database Support
1

I’m pulling my hair out over this one:

I have two columns:

columnA columnB

stuff - null
more stuff - null
null - something
null - more something

Is there any way to create a temporary column or phantom column (columnC) with a select statement to give me:

columnC

stuff
morestuff
something
more something

Any help would be appreciated

2

SELECT ISNULL(columnA, columnB) AS columnC FROM MyTable

See http://msdn2.microsoft.com/en-us/library/aa933210(SQL.80).aspx

Cheers
Ross

3

Ross,

Thank you. This worked like a charm. I knew it was something simple like that. I was initially thinking temporary tables and other crazy things.

Doug