Alex Hubner wrote: >>It is not a bug to be fixed. SQL is case sensitive. > > > Not always. You can have case/accent-insensitive in most SQL sintax, > including data retrieve. LIKE operators and full-text searches can be > case-insensitive, why case-sensitive is mandatory in CF query of > query's?
I should have been more specific. SQL is case sensitive if the collation is case sensitive, which I believe to be the case for ColdFusion (although not explicitly defined). In that light, it is not a bug to be fixed. Jochem ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists