PDA

View Full Version : function IF ELSE string


BubikolRamios
02-18-2008, 04:16 AM
Can't see what is wrong here, getting err 1064 near = 'SI'


DECLARE c_countryCode2 VARCHAR(2);
DECLARE c_language VARCHAR(2);

#...#


IF c_countryCode2 = 'SI' THEN
c_language = 'SI';
ELSE
c_language = 'GB';
END IF;


thanks for help

BubikolRamios
02-18-2008, 04:26 AM
this works

IF c_countryCode2 = 'SI' THEN
SET c_language = 'SI';
ELSE
SET c_language = 'GB';
END IF;