I remember you could do something like
Select
citizen_type = CASE
WHEN citizen_id == 1 THEN 'Citizen'
WHEN citizen_id == 2 THEN 'National'
WHEN citizen_id == 0 THEN 'Non-Citizen'
end
from candidate
where candidate_id = cfqueryparam value= cfsqltype= /
I know I have to have
Message-
From: Loathe [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 07, 2005 9:47 AM
To: CF-Community
Subject: SQL Server CASE and CAST at once?
I remember you could do something like
Select
citizen_type = CASE
WHEN citizen_id == 1 THEN 'Citizen'
WHEN citizen_id == 2 THEN 'National