Re: [sqlite] [solved] Problem with WHEN expressions inside CASE statement in SELECT statement

Kurt Welgehausen wrote: Robert Duff <[EMAIL PROTECTED]> wrote: I had a problem with inserting bad unicode characters into my database. ... Returned by "SELECT locationsFK,variable,logindex, CASE units WHEN units ISNULL THEN '#!#!#!#!#!#!#!#!#!#!' WH

[sqlite] Problem with WHEN expressions inside CASE statement in SELECT statement

I had a problem with inserting bad unicode characters into my database. In the proccess of running an upgrade, I thought I would filter units like '??F' into '°F'. I believe I have the right logic, but the WHEN expressions of my CASE statement never seem to fire, only the ELSE expression. For