Problem with creating a statement based on variables

[Hans Karlsson]

I want to insert a string (YYYY-MM) in a table. The field is of type CHAR. The value in the INSERT-string is based on variables.

CREATE PROCEDURE `Test`.`TestPart2`(dteFromdat DATE)
.....
#Create the YearMonth variable
IF MONTH(dteFromDat)<10 THEN
SET txtYearMonth=CONCAT(YEAR(dteFromDat), '-0', MONTH(dteFromDat));
ELSE
SET txtYearMonth=CONCAT(YEAR(dteFromDat), '-', MONTH(dteFromDat));
END IF;

#Create the statement
SET @QUERY = CONCAT('INSERT INTO tblKorrlogg SET KorrDate=CURDATE(), YearMonth=', txtYearMonth);
PREPARE stmt FROM @QUERY;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
.......

The statement seem now to looks like this "INSERT INTO tblKorrlogg SET KorrDate=CURDATE(), YearMonth=2009-05"

My problem is how ho add the apostrophes round 2009-05 so it looks like '2009-05' and MySQL will recognize the value as a string.


/Hans Karlsson