| Author |
Topic |
|
wazupjohn1
Starting Member
8 Posts |
 Posted - 2010-04-23 : 13:51:58
|
| I would like to convert all the data in a column of a table in SQL to proper case. The table name is insurance and the column is city. So EL PASO will be El Paso. Need to keep all the spaces in between words. The don't want the entire table, just the column. Can someone help. I'm new at this. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-23 : 14:02:19
|
| isnt this a presentation issue? why do u need to do this in table? you can always do this formatting while displaying by using a formatting function at front end------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
wazupjohn1
Starting Member
8 Posts |
Posted - 2010-04-23 : 14:05:00
|
| The column already has several thousand cities that I need to convert to proper case. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-23 : 14:05:58
|
quote:
Originally posted by wazupjohn1
The column already has several thousand cities that I need to convert to proper case.
but thats easily achievable during displaying at front end, no need to change table for that reason------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wazupjohn1
Starting Member
8 Posts |
Posted - 2010-04-23 : 14:14:05
|
| I don't know how to change tables though. And the information in already in upper case. It's not my database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wazupjohn1
Starting Member
8 Posts |
Posted - 2010-04-23 : 14:24:26
|
| Can you give an example? I am really new at this? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
wazupjohn1
Starting Member
8 Posts |
Posted - 2010-04-23 : 14:49:30
|
| LOL..I guess thats all im going to get huh? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-04-23 : 15:02:14
|
| Tara provided everything you need to complete your original request.Terry- Edit: Sorry Tara, sniped again!!-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher |
|
|
|
wazupjohn1
Starting Member
8 Posts |
Posted - 2010-04-23 : 15:08:59
|
| She did if i knew what i was doing..thanks |
|
|
|
|
Proper Case Script in SQL