MS SQL problem

[tonto]

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

 

[tetranz]

SELECT ISNULL(columnA, columnB) AS columnC FROM MyTable

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

Cheers
Ross

 

[tonto]

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