I have some SQL select queries that act case-insensitive and others that only return values that match the string case between the CF string variable and the SQL field value requested.
I can address it by setting the CF value with "Ucase" and the SQL value with "UPPER", but I don't think it should be necessary since I have other queries that return case-insensitive results without making case conversions. Any ideas on what's causing only case matches to be returned from a SELECT query? Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
