Convert all UPPERCASE to Capitalized ??

[spacepoet]

Hello:

 

Is there a feature or function (SQL Query) that can be used to change all UPPERCASE to just Capitalize the first letter of each word?

 

I have a zipcode database and all the town names and state names are UPPERCASE, which is a bit unsightly and harder for the user to read.

 

Anyway to do this?

[darkfreaks]

Lower or Upper or Lcase() 

[spacepoet]

Hi:

 

Thanks, but not sure if I follow you.

 

Is it a SQL Query that I would run in mySQL?

 

Like:

TO CAPITALIZE in zip_codes WHERE Column = towns

 

Something like that?

[Pikachu2000]

I don't believe mysql has a function that does that. PHP has ucwords, though.

[darkfreaks]

Select  LCASE(first_name) from table;

willoutput

 

first name

 

instead of

 

FIRST NAME

 

ucase does the opposite

SELECT UCASE(first_name) from table

 

will output

 

FIRST NAME

 

instead of

 

first name

 

 

if that doesnt work you can try this capitalize function that someone wrote for MYSQL.

 

http://joezack.com/index.php/2008/10/20/mysql-capitalize-function/

 

 

 

[Pikachu2000]

The OP wants the first letter of each word capitalized.

[darkfreaks]

that's why i linked a page to a MYSQL capitalize function which does exactly that 

[rajiv]

SELECT CONCAT( UCASE(LEFT(TRIM('MYSTRING'), 1)), UCASE(SUBSTRING(TRIM('MYSTRING'), 2)) );

 

This will capitalise all selected values..

 

This may helpful for you.. TreeShore

[Pikachu2000]

that's why i linked a page to a MYSQL capitalize function which does exactly that 

 

I was using the WAP site my phone; the link didn't even show up on the screen . . .

[spacepoet]

Hi all:

 

Thanks for all the input.

 

I'm going to try the Capitalize FUNCTION and see how that goes.

 

Looks like it makes sense.

 

Thanks!

[fenway]

Besides, you can't be certain you even want every word capitalize.