Can select small letter or capital letter

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Can select small letter or capital letter

Author

Topic

seyha_moth
Yak Posting Veteran

74 Posts

Posted - 2007-02-21 : 20:17:53

Dear Sir or Madam

I have a problem related to select query.I have the follwing record:

Name Sex
1-Seyha M
2-Chan F
3-sitha M
4-cheta M

I want to use select query to retrive Name start with small letter 's'
but it always show both 's' and 'S'

select * from table1 where Name='%s%'

I look forward to hearing from you
Thank you in advance
Best Regard

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-21 : 20:45:02

SQL server uses a case insensitive collation by default.

google finds this solution for you http://www.mssqltips.com/tip.asp?tip=1032

-ec

Kristen
Test

22859 Posts

Posted - 2007-02-21 : 21:07:05

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Making%20Upper,Lower%20Case%20Sensitive%20comparison

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources