Thursday, February 16, 2012

Changing Fiirst Letter to capital

Hello there
Is there a simple way to change first letter on string to capital letter?"Roy Goldhammer" <roy@.hotmail.com> wrote

> Is there a simple way to change first letter on string to capital letter?
write user-defined function.
CREATE FUNCTION dbo.FirstCapital (@.str VARCHAR(255))
RETURNS VARCHAR(255)
AS
BEGIN
DECLARE @.FirstLetter CHAR(1)
SET @.FirstLetter = LEFT(@.str,1)
IF @.FirstLetter between 'a' and 'z'
SET @.FirstLetter = CHAR(ASCII(@.FirstLetter) + (ASCII('A') - ASCII('a')))
SET @.str = @.FirstLetter +RIGHT(@.str, LEN(@.str)-1)
RETURN @.str
END
Then
SELECT dbo.FirstCapital ('test string')|||didn't wake up yet
CREATE FUNCTION dbo.FirstCapital (@.str VARCHAR(255))
RETURNS VARCHAR(255)
AS
BEGIN
RETURN UPPER(LEFT(@.str,1))+RIGHT(@.str, LEN(@.str)-1)
END
"Anatoli Dontsov" <Anatoli@.dontsov.com> wrote in message
news:eJ9pjtOUGHA.5808@.TK2MSFTNGP12.phx.gbl...
> "Roy Goldhammer" <roy@.hotmail.com> wrote
>
> write user-defined function.
> CREATE FUNCTION dbo.FirstCapital (@.str VARCHAR(255))
> RETURNS VARCHAR(255)
> AS
> BEGIN
> DECLARE @.FirstLetter CHAR(1)
> SET @.FirstLetter = LEFT(@.str,1)
> IF @.FirstLetter between 'a' and 'z'
> SET @.FirstLetter = CHAR(ASCII(@.FirstLetter) + (ASCII('A') - ASCII('a')))
> SET @.str = @.FirstLetter +RIGHT(@.str, LEN(@.str)-1)
> RETURN @.str
> END
>
> Then
> SELECT dbo.FirstCapital ('test string')
>

No comments:

Post a Comment