Solved

Find space in SQL String and Change to Proper case

Posted on 2008-06-12
4
3,406 Views
Last Modified: 2012-06-27
Hi Experts
I have a SQL table which contains all Upper Case data.  I moving it from this table to another table where the Data is Proper case ( from PAUL to Paul )  I am not  having any problem with the data when the field only contains one word but when it has two words such as City: NEW YORK I need to find the space with a substring or something to chang it from NEW YORK to New York.  Does anyone have sample SQL code for this?  Thanks
0
Comment
Question by:millerfw
  • 2
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
floook earned 500 total points
ID: 21774969
Here http://weblogs.sqlteam.com/jeffs/archive/2007/03/09/60131.aspx.
Make sure you read all comments to pick the best solution.
0
 

Author Comment

by:millerfw
ID: 21783709
Thanks floook  this worked perfect
0
 
LVL 2

Expert Comment

by:floook
ID: 21795576
Can I get the points then? :o)
0
 

Author Comment

by:millerfw
ID: 21795608
Sorry I thouht I had awarded the points
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now