Prev: Subquery help
Next: sql commands for datediff
From: Eric S on 12 Jan 2010 19:26
Hi All,

Is there any function that converts the first character to upper case?
Then the rest of the letters into lower case...

Thanks,

Eric

From: Eric Isaacs on 12 Jan 2010 19:45
Here's a user defined function that does proper casing...

http://weblogs.sqlteam.com/jeffs/archive/2007/03/09/60131.aspx

-Eric Isaacs
From: Eric S on 13 Jan 2010 14:03
Thanks,
I thought there was a PROPER() function in ms sql and could not find
that.<s>

"Eric Isaacs" <eisaacs(a)gmail.com> wrote in message
news:bc57dea7-5490-4de2-9916-657e8515767f(a)z41g2000yqz.googlegroups.com...
> Here's a user defined function that does proper casing...
>
> http://weblogs.sqlteam.com/jeffs/archive/2007/03/09/60131.aspx
>
> -Eric Isaacs

 | 
Pages: 1
Prev: Subquery help
Next: sql commands for datediff