title: Case when only returnng numeric results
body: <p>I am using a CASE WHEN statement to select alpha numeric data, but the statement will only return the rows that are numeric.</p>
  
  <p>When creating the table, I defined the row as "CarPlate1" TEXT When selecting the data I run a query similar to the one below, only mine searches over several columns, ie CarPlate1, CarPlate2 and CarPlate3.</p>
  
  <p><code>SELECT "CarPlate1", "dbcarplate", CASE WHEN "CarPlate1" = '+readlpr+' THEN "CarPlate1"  ELSE '+null+' END dbcarplate FROM "SiteDB" ORDER BY dbcarplate DESC LIMIT 3;</code></p>
  
  <p>Stored alpa numeric fields return the following error message</p>
  
  <p><code>"Error: SQLITE_ERROR: no such column: ABCDE1234"</code> </p>
  
  <p>where ABCDE1234 is the data that is being searched for, but the query will produce the required results for numeric only data.</p>
  
  <p>Need to get back data like ABCDEFGH, ABCDE1234, or 98341 </p>