Forum Discussion

HarshaChilakala's avatar
HarshaChilakala
Copper Contributor
May 06, 2024
Solved

How to fetch??

How to fetch the customers names, who's having first letter CAPITAL ??
  • olafhelper's avatar
    olafhelper
    May 07, 2024

    HarshaChilakala , by using a  CS = "Case Sensitive" collation, for example:

     

    ;WITH names AS
    (SELECT 'Smith' AS name UNION ALL
     SELECT 'Miller' UNION ALL
     SELECT 'taylor')
SELECT *
FROM names
WHERE LEFT(name, 1) COLLATE SQL_Latin1_General_CP1_CS_AS = UPPER(LEFT(name, 1)) COLLATE SQL_Latin1_General_CP1_CS_AS
olafhelper's avatar
olafhelper
Bronze Contributor
May 07, 2024

HarshaChilakala , by using a  CS = "Case Sensitive" collation, for example:

 

;WITH names AS
    (SELECT 'Smith' AS name UNION ALL
     SELECT 'Miller' UNION ALL
     SELECT 'taylor')
SELECT *
FROM names
WHERE LEFT(name, 1) COLLATE SQL_Latin1_General_CP1_CS_AS = UPPER(LEFT(name, 1)) COLLATE SQL_Latin1_General_CP1_CS_AS

Resources