Test for first letter capitalisation like so in ms sql 2005

[nikos101]

I'm trying to test for first letter capitalisation like so in ms sql 2005

SELECT [Id]
      ,[Code]
      ,[Country]
  FROM [[Currency]
 
  WHERE Country LIKE '[A-Z]%'

however I get everything back?

[Dileep_NR]

SELECT [Id]
      ,[Code]
      ,[Country]
  FROM [[Currency]
 
  WHERE Country REGEXP '^[A-Z]';

Also please refer

http://www.go4expert.com/forums/showthread.php?t=2337

[nikos101]

thats mysql

[Dileep_NR]

ohhh.. Sorry

try this

http://sqltips.wordpress.com/2007/05/14/case-sensitive-string-comparison-in-sql-server-2005/

[Dan_Bracuk · Accepted solution]

where substring(country, 1, 1) between 'A' and 'Z'

[nikos101]

awesome