HI, Thanks for your answer. However for different reason it is not acceptable for me to use the Lower() in the original query. So I think in this case, I will replace the QoQ by an Oracle view, which will do the thing ...
Dominique -----Original Message----- From: Tim Painter [mailto:cftalk@;cfex.com] Sent: Thursday, October 31, 2002 5:45 PM To: CF-Talk Subject: Re: CF MX Query of Query Lower() Function I believe qoq has a very limited set of functions available. To get around that, I set the original query to also retrieve the name in lower case and in my qoq, search on the lower case set field. e.g <cfquery name="qry1" datasource="bar"> Select firstname, lower(firstname) as lower_first from mytable </cfquery> <cfquery name="qry2" dbtype="query"> Select firstname from qry1 where lower_first like '%mat' </cfquery> HTH, Tim P. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.