TI Logbook
Java, Angular, Eclipse, PostgreSQL, SQL, Tips....
Thursday, February 4, 2016
SQL Server SELECT CASE and convert in VARCHAR
numberValue is an number
SELECT CASE numberValue
WHEN 1 THEN 'State 1'
WHEN 2 THEN 'State 2'
WHEN 3 THEN 'State 3'
ELSE CAST (numberValue AS VARCHAR(50))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment