On Feb 8, 2012, at 12:14 AM, Bart Smissaert wrote: > Have a table with an integer age field and a text age_group field.
Are you 100% positive that you have a number and not a text?
Contrasts:
select case
when '1' between 0 and 9 then '0 to 9'
end as band
Vs.
select case
when 1 between 0 and 9 then '0 to 9'
end as band
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
