Solved

Find space in SQL String and Change to Proper case

Posted on 2008-06-12
4
3,412 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

724 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