Solved

sql query help

Posted on 2015-01-06
1
73 Views
Last Modified: 2015-01-06
hi all
i have customer field name as custfield and the data is stored as "NYS INCOME TAX,"
i want to remove those quotes in the front and the end and remove the ,
i need something like this NYS INCOME TAX
can someone tell me how to do this in sql query
0
Comment
Question by:romeiovasu
1 Comment
 
LVL 13

Accepted Solution

by:
Koen Van Wielink earned 500 total points
ID: 40534797
Use this:

update yourTable
set custfield = REPLACE(REPLACE(custfield, '"', ''),',','')

Open in new window


Of course you have to be sure there are no quotes and commas in the string itself that you want to keep. If there are, we have to modify the logic a bit.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Run an action on recently added records to a table 13 63
SQL Quer 4 22
RAISERROR WITH NOWAIT 2 17
SQL Error when trigger fires in SQL Server 2008 R2 6 16
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

828 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