SQL-Server

Moderators: None (Apply to moderate this forum)
Number of threads: 423
Number of posts: 776

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Is SQL sensitive for capital letters ? Posted by ampo on 23 Mar 2004 at 6:15 AM
Can I differ "Hello" from "hello" in:

select * from tblName where fieldName like '%Hello%' (not '%hello%')

thanks
Report
Re: Is SQL sensitive for capital letters ? Posted by Xtreme.NET on 29 Mar 2004 at 7:55 PM
never really tried this...
wait a sec. lemme try it..
ok..
i tried your statement and it still worked fine!
even when i changed the case...


"Rejoice always, pray without ceasing, in everything give thanks; for this is the will of God in Christ Jesus for you."[i]1Thess. 5:16-18[/i]

Report
Re: Is SQL sensitive for capital letters ? Posted by abhishek12 on 9 Jun 2004 at 9:02 AM
: Can I differ "Hello" from "hello" in:
:
: select * from tblName where fieldName like '%Hello%' (not '%hello%')
:
: thanks
:
: It is possible to make the SQL Server Case Sensitive. It can be done only while Installating SQL Server on your machine. Before making any changes, remember that the changes are server specific i.e. they will be according to the SQL Server installed on the server.
If you have already installed SQl Server once again, you can do so by changing the collation settings. However, you will be needing to rebuild the master database and mind you dont want to do that if you are doing it on a production database.
You need to be very careful while making it Case Sensitive because even a "SELECT" will not work while "select" will give you the output depending on your settings. So my suggestion is, do not go for Case Sensitive SQL Server.




 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.