SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Collation for finding difference in lower/uppercas
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Robowski
Posting Yak Master

101 Posts

Posted - 04/17/2013 :  07:27:56  Show Profile  Reply with Quote
Just more of a general question really,

when ever I need to compare a field for a a difference in character case I.e if someone has entered something into table.column in lower case when it should have been upper I convert to varbinary

But I vaguely remember reading something about you can change the collation of the string to also find this out?

Anyone know/does this make sense?

Cheers

Robbo

bandi
Flowing Fount of Yak Knowledge

India
2206 Posts

Posted - 04/17/2013 :  07:45:54  Show Profile  Reply with Quote
SELECT Column1
FROM Table1
WHERE Column1 COLLATE Latin1_General_CS_AS = 'casesearch'

Refer
http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
http://msdn.microsoft.com/en-in/library/ms144250(v=sql.105).aspx

--
Chandu
Go to Top of Page

Robowski
Posting Yak Master

101 Posts

Posted - 04/17/2013 :  08:45:55  Show Profile  Reply with Quote
thanks for the info, always good to know other ways!
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2206 Posts

Posted - 04/18/2013 :  02:35:03  Show Profile  Reply with Quote
quote:
Originally posted by Robowski

thanks for the info, always good to know other ways!


Welcome

--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/18/2013 :  03:10:51  Show Profile  Reply with Quote
you can also have other approaches like this

http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000