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 |
|
cardgunner
326 Posts |
 Posted - 2007-06-12 : 14:15:45
|
| I just imported a dbf file. There is a column in that file with street addresses. The addresses are in both caps and smallercase. I think I know the answer to this but, Does SQL recognize a difference?Meaning PO BOX 1 is not the same as Po Box 1, right?If that is right is there a way to change it, or a command to accept that these two are the same?because i want it to recognize the PO BOX 1 = Po Box 1.Card Gunner |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
cardgunner
326 Posts |
Posted - 2007-06-12 : 14:31:21
|
| I think I did. I will look harder to see any other. I know when I ask as an example: machine.type in ('FORD', 'CHEVY','gMC','DODGE') it will not give me any GMC's because of the G and the g.Card Gunner |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-12 : 16:52:18
|
| See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Making%20Upper,Lower%20Case%20Sensitive%20comparison |
|
|
|
|
|
|
CAPS AND smallercase matching