I have one more question for the da

[vorvad]

I have one more question for the day.
I am having problems finding help on 'if else' constructs.

I want to do the following:

select cola if cola > colb else colb
from mytable

Thanks in advance!
VB

 

[tlbroadbent]

If... Else... Is used for control of flow in T-SQL. You should use the CASE statment in queries.

Select
Col=Case
When cola > colb
Then cola
Else colb
End
From mytable Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[bperry]

Here's one way:

Select (CASE When Cola > Colb then Cola else Colb END) as TheColumn