Sam Carleton <scarle...@miltonstreet.com> wrote: > On Sun, Jun 20, 2010 at 4:52 PM, P Kishor <punk.k...@gmail.com> wrote: >> >> No. WHERE clause is a completely different part of the statement, >> different from WHEN which is a part of the CASE construct. "CASE.. >> WHEN .. THEN .. ELSE .. END" is one construct, an expression, and >> applies to the columns, while WHEN is a completely different part. > > Thank you, unfortunately I am still 100% clueless as to how to use the > CASE ... WHEN ... THEN ... ELSE ... END to solve this pseudo code > problem in one SQL statement:
In what way did the statement I gave you, exactly as written, fail to satisfy your requirements? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
