Latest ads

RHCSA, RHCE, AWS, Docker, Kubernetes Training
- Sanjeewani95
- Updated: Tuesday at 10:28 AM
🛡️ Kaspersky Antivirus – 1 Year / 1 Device | Rs. 2,300 | Only 9 Left
- KSPathirana
- Updated: Monday at 2:42 PM
Ad icon
Professional CCTV Installation Service
- Techguy231
- Updated: Sunday at 10:50 AM
Ad icon
I'll research & write an article - Rs. 2000 onwards
- Blogerwiki
- Updated: Sep 3, 2026
House Plan
- lenura
- Updated: Sep 2, 2026

Reply to thread

Message: <blockquote data-quote="Nohim Ys" data-source="post: 14337903" data-attributes="member: 370237"><p><span style="font-size: 15px">Have you ever noticed when you do a string comparison in SQL using '=' notation, case of the string is neglected ???</span></p><p><span style="font-size: 15px">For example, If TestTable has a TestColumn and it consist of  values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records.</span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px">If you dont want to ignore case and return only the exact row with the specified value, the query should be modified as follows,</span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px">The above change should be done since the default Collation of the SQL Server installation SQL_Latin1_General_CP1_CI_AS is not case sensitive.</span></p><p></p><p></p><p><span style="font-size: 18px">Picked this from here - </span><a href="http://darshanaspinx.blogspot.com/2012/09/case-sensitive-sql-query-search.html" target="_blank"><span style="font-size: 18px"><span style="color: DarkRed">Reference</span></span></a></p></blockquote><p></p>

Verification: Awruddata maasa keeyada?

Top Bottom