Have a table with an integer age field and a text age_group field. Need to update the age_group field according to the age. Tried with several case when constructions, but sofar nil working, eg:
update pats set age_group = (case when age between(0 and 9) then '0 to 9' when age between(10 and 19) then '10 to 19' when age between(20 and 29) then '20 to 29' when age between(30 and 39) then '30 to 39' when age between(40 and 49) then '40 to 49' when age between(50 and 59) then '50 to 59' when age between(60 and 69) then '60 to 69' when age between(70 and 79) then '70 to 79' when age between(80 and 89) then '80 to 89' when age between(90 and 99) then '90 to 99' when age > 99 then '100 and above' end) How can this be done? RBS _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
