[sqlite] What is wrong with this SELECT CASE statement?

[RB Smissaert]

Trying to update my yyyymmdd integers to months with a SELECT CASE
statement:

SELECT CASE
(CAST(DATE_OF_BIRTH / 100 AS INTEGER) - CAST(DATE_OF_BIRTH / 10000 AS
INTEGER) * 100)
WHEN 1 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'January'
WHEN 2 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'February'
WHEN 3 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'March'
WHEN 4 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'April'
WHEN 5 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'May'
WHEN 6 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'June'
WHEN 7 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'July'
WHEN 8 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'August' 
WHEN 9 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'September'
WHEN 10 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'October'
WHEN 11 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'November'
WHEN 12 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'December'
END
FROM A2IDC21_J

But no updates take place.
Thanks for any advice.

RBS




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------