The function is upper()

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:bounce-cfaussie-
> [EMAIL PROTECTED] On Behalf Of Toby Tremayne
> Sent: Thursday, 20 November 2003 1:30 p.m.
> 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 leave-cfaussie-
> [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

Reply via email to