is your SQL Server set-up to be case sensitive? If not, don't worry about it...
-----Original Message----- From: Toby Tremayne [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 November 2003 11:30 AM To: CFAussie Mailing List Subject: [cfaussie] query of query functions Hi All, when you're doing a QoQ, is there anyway to upper case something you're checking against? For instance in sql server I'd do this: where UPPER(status) = '#uCase(myVar)#' but I can't find an equivalent for QoQ - am I just stuck? cheers, Toby -------------------------------- Life is Poetry, write it in your own words -------------------------------- Toby Tremayne Cold Fusion Developer Code Poet and Zen Master of the Heavy Sleep Virtual Tours +61 416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
