I need a simple CASE construct.  Does QODBC have such?

For example, in Microsoft SQL, I could simply say:

SELECT CASE WHEN IsPending = 0 THEN 'False' ELSE 'True' END as ISPENDING from InvoiceLine

If not, is there any other "conditional" that I could use in a select statement?

TIA!

The use of

CASE sql_expression
     WHEN sql_expression_value THEN return_value
     ELSE return_value

or

CASE 
     WHEN sql_Boolean_expression THEN return_value
     ELSE return_value

is currently not supported by QODBC. You will need to build the construct around a WHERE, AND, OR.

Thanks for the confirmation, Tom. 

At least I know what my limits are.  Unfortunately, this is very disheartening.  

A valid CASE construct (or inline IF THEN ELSE) allows variable data to be returned for a given column, for whatever records are being returned.

Using a WHERE statement with AND and OR merely controls the records returned by the select statement, which is drastically different.

With this approach, I have to break-up my select statement into multiple select statements, which is not acceptable for this particular need, as I MUST have a single result set.  This WOULD be acceptable if I could UNION the multiple result sets, but it doesn't appear UNION is supported by QODBC either.

Again, thanks for the confirmation.