Roshworld

Monday, September 7, 2009

SQL Server Case sencitive Query

Just put COLLATE Latin1_General_CS_AS allong with WHERE condition

ex:

SELECT * from tbl_User
WHERE State COLLATE Latin1_General_CS_AS = 'nc'
Posted by Rosh Mohan at 9:35 PM No comments:
Labels: case sensitive query, SQL server case sensitive
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2021 (1)
    • ►  March (1)
  • ►  2020 (1)
    • ►  August (1)
  • ►  2019 (10)
    • ►  July (1)
    • ►  June (1)
    • ►  April (5)
    • ►  March (2)
    • ►  February (1)
  • ►  2014 (2)
    • ►  July (2)
  • ►  2013 (1)
    • ►  August (1)
  • ▼  2009 (11)
    • ▼  September (1)
      • SQL Server Case sencitive Query
    • ►  August (3)
    • ►  May (1)
    • ►  March (4)
    • ►  February (2)
  • ►  2008 (8)
    • ►  November (1)
    • ►  October (1)
    • ►  September (2)
    • ►  July (1)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
  • ►  2007 (9)
    • ►  December (2)
    • ►  November (1)
    • ►  October (6)
Simple theme. Theme images by gaffera. Powered by Blogger.