using case, Valid statement?
From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Thu, 19 Feb 2004 10:27:15 -0600
Message-ID: <4034E3E3.72401616_at_ram.lmtas.lmco.com>
Date: Thu, 19 Feb 2004 10:27:15 -0600
Message-ID: <4034E3E3.72401616_at_ram.lmtas.lmco.com>
Is this a valid sql statement:
SELECT
case field1
when 'first' then 1
when 'second' then 1
else null
end
FROM mytable
Mike Received on Thu Feb 19 2004 - 17:27:15 CET