Posted: Tue Feb 08, 2005 3:51 pm Post subject: case statement
Newbie
Joined: 24 Jan 2005 Posts: 2 Location: Jacksonville
Pl verify this: Its giving Syntax error
DECLARE STR CHAR;
SET STR='10-12-2005';
SET STR1=SUBSTRING(STR FROM 1 FOR 2);
SET STR2=SUBSTRING(STR FROM 4 FOR 2);
SET STR3=SUBSTRING(STR FROM 7 FOR 4);
CASE
WHEN STR1='01' THEN SET STR1='January';
WHEN STR1='02' THEN SET STR1='February';
WHEN STR1='03' THEN SET STR1='March';
WHEN STR1='04' THEN SET STR1='April';
WHEN STR1='05' THEN SET STR1='May';
WHEN STR1='06' THEN SET STR1='June';
WHEN STR1='07' THEN SET STR1='July';
WHEN STR1='08' THEN SET STR1='August';
WHEN STR1='09' THEN SET STR1='September';
WHEN STR1='10' THEN SET STR1='Octomber';
WHEN STR1='11' THEN SET STR1='November';
WHEN STR1='12' THEN SET STR1='December';
END;
Joined: 28 Jun 2001 Posts: 2453 Location: Los Angeles
Quote:
CASE
WHEN STR1='01' THEN SET STR1='January';
WHEN STR1='02' THEN SET STR1='February';
WHEN STR1='03' THEN SET STR1='March';
WHEN STR1='04' THEN SET STR1='April';
WHEN STR1='05' THEN SET STR1='May';
WHEN STR1='06' THEN SET STR1='June';
WHEN STR1='07' THEN SET STR1='July';
WHEN STR1='08' THEN SET STR1='August';
WHEN STR1='09' THEN SET STR1='September';
WHEN STR1='10' THEN SET STR1='Octomber';
WHEN STR1='11' THEN SET STR1='November';
WHEN STR1='12' THEN SET STR1='December';
END CASE;
Or:
Quote:
SET STR1 = CASE STR1
WHEN '01' THEN 'January';
WHEN '02' THEN 'February';
WHEN '03' THEN 'March';
WHEN '04' THEN 'April';
WHEN '05' THEN 'May';
WHEN '06' THEN 'June';
WHEN '07' THEN 'July';
WHEN '08' THEN 'August';
WHEN '09' THEN 'September';
WHEN '10' THEN 'Octomber';
WHEN '11' THEN 'November';
WHEN '12' THEN 'December';
END;
Cheers, _________________ Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum