SQLite Forum

nested case statement not working
Login
Thanks Keith!  That helped.  I had not realized that the data, actually taken from DB2 and being CHAR(8), contained trailing spaces for those with shorter lengths.