Case Sensitive QofQ and Operators

2013-04-09 Thread Brian Thornton
If you have a solution that would be great, and an explanation would be even better... Here's my quandary . without UPPERing or LOWERing my results out of MSSQL can I do a equal operator and ignore casing? According to Adobe (

Re: Case Sensitive QofQ and Operators

2013-04-09 Thread Captain Obvious
Use the UPPER operator native to your SQL dialect or set a cf var to the desired value and then use that var to construct your query. On Apr 9, 2013 11:45 AM, Brian Thornton br...@cfdeveloper.com wrote: If you have a solution that would be great, and an explanation would be even better...