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: arslist@ARSLIST.ORG 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 correctly, the AR System can be set up on MS SQL in a manner that searches are not case sensitive. If I remembered correctly what steps need to be taken to set up MS SQL correctly. Also if I remember correctly FTS is not really needed on an AR System running MS SQL. Is my memory correct or am I just having a bad day? Thanks, Dave Dave Shellman Phone: (717) 810-3687 Fax: (717) 810-2124 email: [EMAIL PROTECTED] Tyco Electronics MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
