Ah - yes, then. SQL is case-insenstive. Rick _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, September 14, 2007 9:56 AM To: [email protected] Subject: Re: Case Sensitive searches
Sorry the question was supposed to be asked for MS SQL instance. ------Original Message------ From: Rick Cook To: Arslist ReplyTo: Arslist Sent: Sep 14, 2007 12:52 PM Subject: Re: Case Sensitive searches ** Yes, *** IF *** the DB was set up that way. Just because 10G and above CAN be set that way doesn't mean that they WERE set up that way. Talk to your DBAs. Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, September 14, 2007 9:46 AM To: [email protected] Subject: Re: Case Sensitive searches We're running on Oracle. Asking the question for one of our other divisions that just setting up on MS SQL. So a search for 'field' = "bmc" should return data where the field was set to BMC, Bmc, or bmc. ------Original Message------ From: Rick Cook To: Arslist ReplyTo: Arslist Sent: Sep 14, 2007 12:35 PM Subject: Re: Case Sensitive searches ** SQL is, by default, a case-insensitive DBMS, and has been for the past several versions. I don't even know how to set it up any other way, or why someone would want to. The last major DBMS to not be like this was Oracle - I think 9i was the last one that could not be easily set up case-insensitive. Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, September 14, 2007 9:25 AM To: [email protected] Subject: Case Sensitive searches ** I know this has been answered before. My searches just haven't found the answer on the ARS List or BMC/Remedy Support. If I remember ------Original Message Truncated------ Dave -------------------------- [EMAIL PROTECTED] (Wireless) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
