Do we know for sure that you can nest IFF statements? I've never tried it. Maybe test first by replacing the second IFF with a simple "IFEQ" statement just to test if that works
Karen -----Original Message----- From: Bruce Chitiea <[email protected]> To: [email protected] <[email protected]> Sent: Wed, Jun 16, 2021 3:15 pm Subject: [RBASE-L] - IFF Function Quandry #yiv8696988414 #yiv8696988414xac10712db59143e #yiv8696988414x86b4dd35dfc94ef5a5432fdb70f5f643{font-family:'Segoe UI';font-size:12pt;}#yiv8696988414 blockquote.yiv8696988414cite {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;}#yiv8696988414 blockquote.yiv8696988414cite2 {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;margin-top:3px;padding-top:0px;}#yiv8696988414 a img {border:0px;}#yiv8696988414 RBGX5E Current (Best viewed in monospaced font) The trxMonth and trxQuarter columns are each defined as TEXT (2). This statement: UPDATE fts_input_tt +SET trxQuarter = +(IFF('trxMonth IN (1,2,3)','Q1','xx')) ... correctly updates trxQuarter with value Q1 where the value of trxMonth is in (1,2,3) and with 'xx' for all other values of trxMonth. This statement: UPDATE fts_input_tt +SET trxQuarter = +(IFF('trxMonth IN (1,2,3)','Q1', +(IFF('trxMonth IN (4,5,6)','Q2','XX')))) ... returns the error: Parentheses required around the list of items for the IN clause. (2304) ... and aborts the UPDATE. ??? Thanks for your assistance Bruce A. Chitiea | SafeSectors, Inc.112 Harvard Ave #272 | Claremont CA 91711-4716 | [email protected] | +011 (909) 238-9012 c | +011 (909) 912-8678 f -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em64238e39-bec5-4762-8c3e-79ad6040a5f5%40pathfinder. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/143382711.676998.1623874722191%40mail.yahoo.com.
