A toupper command available

[Carlos Fernandez]

Hey I just wanted to know if anyone knew what the command for
making some data in the SQL database into all upper or lower case
and if it is possible to just affect all other letter besides the first one.
For example if I wanted to alter
TODAY'S NEWEST TECHNOLOGY IN THE MARKET
to
Today's newest technology in the market

How would I do this please help thanx

carlos

[Daniel Reber]

Carlos,
You should first update the field to all lower case.

UPDATE mytable
SET myfield = lower(myfield)

Then change the first letter to all upper case.

UPDATE mytable
SET myfield = upper(substring(myfield,1,1)) + substring(myfield,2,(LEN(myfield)-1))

That should work for you.

Daniel Reber, MCP



"Carlos Fernandez" <cfernan29@loyaltyworks.com> wrote:
>
>Hey I just wanted to know if anyone knew what the command for
>making some data in the SQL database into all upper or lower case
>and if it is possible to just affect all other letter besides the first
one.
> For example if I wanted to alter
>TODAY'S NEWEST TECHNOLOGY IN THE MARKET
>to
>Today's newest technology in the market
>
>How would I do this please help thanx
>
>carlos