CASE Statement 1

[dscoiho]

Does anyone have an idea on either better way to write the statement below or why I cant use "TO" for then results?

Trade Month field is a number between 1 and 12 and I cant use the date field in our tables due to certain limitations.

TRADE_MONTH=(CASE WHEN DATEPART(MONTH,GETDATE()) = 1 THEN 1 to 12 ELSE 1 to DATEPART(MONTH,GETDATE())-1 END)

Thanks in advanced.

 

[AlexCuse]

I believe you want something like this. You need to put any 'hard coded' varchar values between apostrophies, and convert the datepart to varchar so that you can

TRADE_MONTH= CASE WHEN DATEPART(MONTH,GETDATE()) = 1 
THEN '1 to 12' 
ELSE '1 to ' + cast(DATEPART(MONTH,GETDATE())-1 as varchar) 
END

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom