Changing Letter Case in SProc

Hi all,
Can anyone tell me how I could manipulate the case of the characters
passed in to a stored procedure as a parameter?
I was hoping there is a function that can turn a parameter into all
lowercase letters, for example.
Many thanks in advance
SimonSee Lower and Upper functions in BOL
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:uXtYorsjGHA.1204@.TK2MSFTNGP02.phx.gbl...
> Hi all,
> Can anyone tell me how I could manipulate the case of the characters
> passed in to a stored procedure as a parameter?
> I was hoping there is a function that can turn a parameter into all
> lowercase letters, for example.
> Many thanks in advance
> Simon|||To force upper case use UPPER() and LOWER() for lower case. e.g.
Select UPPER(firstname), LOWER(lastname) from tblusernames.
Ray
"Simon Harvey" wrote:

> Hi all,
> Can anyone tell me how I could manipulate the case of the characters
> passed in to a stored procedure as a parameter?
> I was hoping there is a function that can turn a parameter into all
> lowercase letters, for example.
> Many thanks in advance
> Simon
>