Software

Ask something
Discussion Locked

Change Case in SQL 2000

0 helpful
5 replies

by geeit

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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'

5 replies

by master3bs

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

by master3bs

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

by tel

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

by bschaettle

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.

This discussion is closed to new replies.