Andrew Jensen ha scritto:
Franco Fornari wrote:
whilst CASEWHEN works for me. Here is an SQL statement I'm using
since a few months:
You are right, just re-ran my test statement:
SELECT "ID", "CHAR_1", "DOUBLE_1", CASEWHEN( "CHAR_1" = 'RC1',
"DOUBLE_1", "DOUBLE_1" / 2 ) AS "RES_1" FROM "Table1"
It does indeed work in the query designer. The spreadsheet has been
updated to reflect this.
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Just a thought about the other two, CASE WHEN and CASE v1 WHEN. They are
the only built-in functions having the name composed by more than one
word. Could they work, if their names were CASE_WHEN and CASE_v1_WHEN,
like many others are?
As I said, just a thought,
best regards,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
