I'm comparing a text box to a field in my database
I want it to give back true only if upper\lower case match and not always when the words are the same. Can you help me?
plusplus
0
Posting Whiz in Training
Recommended Answers
Jump to PostSO you mean to say that the function should treat the upper nad lower case word as two seperate words? Can you be nore specific. I can help you if you explain a bit.
Jump to Postwell the ideal way to handle this is follow a uniform data storage in the database, that will give more control over the database.
You should always follow proper casing when storing the data back to the DB.If you want to be able to compare two case-insensitive strings …
Jump to PostUse this query and it should definitely work
Select * from tblusers where name COLLATE Latin1_General_CS_AS = 'Martin'
WHich version of SQL are you using?
Jump to PostYou can check the SQL version by opening Query Analyzer and click on "Help" --> "About"
Also send me the error message.
All 14 Replies
binoj_daniel
14
Practically a Master Poster
plusplus
0
Posting Whiz in Training
binoj_daniel
14
Practically a Master Poster
plusplus
0
Posting Whiz in Training
binoj_daniel
14
Practically a Master Poster
plusplus
0
Posting Whiz in Training
binoj_daniel
14
Practically a Master Poster
plusplus
0
Posting Whiz in Training
binoj_daniel
14
Practically a Master Poster
plusplus
0
Posting Whiz in Training
binoj_daniel
14
Practically a Master Poster
binoj_daniel
14
Practically a Master Poster
plusplus
0
Posting Whiz in Training
binoj_daniel
14
Practically a Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.