by tesagen
20. august 2009 12:13
ALTER
function [dbo].[fnChkAllCaps1](@P_String Varchar(500
))
--1 = Alle uppecases 0= Ikke alle uppercases
returns
bit
as
begin
return
(select case when @P_String collate SQL_Latin1_General_CP1_CS_AS = upper(@P_String) then 1 else 0 end
)
end
--SELECT dbo.fnChkAllCaps1('TECHTHOUGHTS') -- Returns 0
--GO
--SELECT dbo.fnChkAllCaps1('TechThoughts') -- Returns 1
--GO
Abonnere