Raymond Camden wrote: > CFMX Query of Query has an lcase function. You could use this to do a > non-case sensitive type search. This function did not exist in CF5 > QofQ however.
LCase() throws an syntax error and is not in the docs [1], whereas Lower() is and only throws a null exception when it gets to proces a NULL. Although I can's seem to find either one in the BNF form [2] of the docs, so I think some work is needed there. Jochem [1]http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusion_MX_Applications_with_CFML/using_recordsets4.jsp [2]http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusion_MX_Applications_with_CFML/using_recordsets5.jsp ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com