COLLATE Latin1_General_CS_AS

USE [AdventureWorks2014]
GO
/****** Object:  StoredProcedure [dbo].[coklat1]    Script Date: 5/17/2018 1:24:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[coklat1]
--exec [coklat1]
as
begin
select * from [Person].[Address]
where SUBSTRING(city,1,1) <> upper(SUBSTRING(city,1,1)) COLLATE Latin1_General_CS_AS
end

Tweet