lower and upper cases

[lesina]

Hi guys,

i need some help.

My table fields in my database are in upper cases but i need to change them all leaving them in a special format (each word must start with caps and the rest of the word must be in lower cases).
Example:
Lisbon=Lisbon

Is there a way of doing this in sql??

In another way, this can be done in excel using the proper function.But to achieve that, i would have to import every table into excel format, use the proper function and put the new tables back in the database.

If there is no way of doing this in sql, the excel way is possible??

Thanks a lot in advance

===================
* Marta Oliveira *
===================
marta100@aeiou.pt
-------------------
CPC_TA- Braga
-------------------
Portugal
===================

 

[Tusk]

There is the @PROPER() function in SQL also use it with an UPDATE statement this will work for you.

UPDATE tablename SET columnname = @PROPER(columnname);