Latest ads

Colombo RidhMathraa ’26 🎶✨
- Tmadhusanka
- Updated: Wednesday at 11:58 PM
Ad icon
Colombo PXN V10 Pro Direct Drive Racing Wheel (Under Warranty)
- Abdur Rahman
- Updated: Wednesday at 10:23 PM
Ad icon
USDT ණය සේවාව - USDT Loan Service
- පුරවැසියා
- Updated: Wednesday at 4:54 PM
Ad icon
🎮 INDIAN PSN GIFT CARDS AVAILABLE NOW! 🎮
- madukaperera
- Updated: Tuesday at 12:57 PM
🚀 Google AI PRO – 18 Months | Rs. 850 Only
- lkkolla
- Updated: Monday at 4:56 PM

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: Haya warak paha keeyada? (haya wadi kireema paha)

Top Bottom