Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjnep
Posting Yak Master
191 Posts |
 Posted - 2008-05-02 : 15:33:07
|
| My SQL Server database is not case sensetive.How can I compare like cluase with search for capital and small letter?For exampleSELECT add1 from xcty_all where add1 like '%AL'%'I need only...................10 ltncewwod way AL456 Ruio St. ALNOTDuci Ral Rd MexicoAlbi Road Hawai CAI want to ingore this bold letter on search Sanjeev Shrestha12/17/1971 |
|
|
ocary
Starting Member
12 Posts |
Posted - 2008-05-02 : 16:48:41
|
| One method: you can collate the column in the query.http://sqlserver2000.databases.aspfaq.com/how-can-i-make-my-sql-queries-case-sensitive.html |
 |
|
|
|
|
|
comparing upper and lower on like% Query