General discussion

Locked

Change Case in SQL 2000

By geeit ·
I have a set of tables in a SQL 2000 database. The information (names and addresses) has been entered in 'CAPITAL LETTERS' and I need to alter this to 'Sentence Case'. I can't just use upper and lower as the fields contain details that need capital letters at the start of each word. Does anyone know if there a way of converting this? EG '14 PARK LANE' needs to become '14 Park Lane'

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by master3bs In reply to Change Case in SQL 2000

I know in Oracle you can use INITCAP(String)
UPPER(String) and LOWER(String) should also work.

Collapse -

by master3bs In reply to Change Case in SQL 2000

I know in Oracle you can use INITCAP(String)
UPPER(String) and LOWER(String) should also work.

Collapse -

by master3bs In reply to

sorry for the double post; site problems

Collapse -

by tel In reply to Change Case in SQL 2000

i think you have to create a user defined function that parses the word or string and make use of the upper and lower functions also

Collapse -

by bschaettle In reply to Change Case in SQL 2000

I know this would be a huge pain, but you could export the data to Excel and use the =PROPER() function to convert it, then import it back into SQL Server.

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums