October 7, 2008 04:43pm pdt

07.06.2008 at 05:02PM PDT, ID: 23542173

	[x] Attachment Details

Remove part of string in SQL Database

Asked by NursingCorp in MS SQL DTS, Databases Miscellaneous, SQL Server 2005

Tags: Microsoft, SQL, 2005

I have data in a column called State each state is inside double quotes such as "Maine"

and I want to remove the double quotes so that it is just Maine without double qoutes.

How do I remove the double quotes off of all of the data in this column?

Thanks,
JoeStart Free Trial

Keywords: Remove part of string in SQL Database

	Title
1	Need to preserve double quotes on hid…
2	string.Replace double qoute
3	double and single qoute
4	Handling double qoutes and single qout…
5	To quote or not to Qoute
6	Elimination those pesky commas and d…

Loading Advertisement...

20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628

1. chapmandew 138,810
2. acperkins 103,316
3. nmcdermaid 82,712
4. cs97jjm3 48,319
5. mark_wills 44,585
6. angelIII 41,135
7. PedroCGD 39,380
8. brejk 36,600
9. EugeneZ 36,222
10. frankytee 27,691
11. dready 20,000
12. matthews... 18,750
13. bhess1 16,550
14. aneeshatti... 14,002
15. Zberteoc 13,800
16. rickchild 13,750
17. momi_sa... 11,250
18. rboyd56 10,525
19. MohammedU 10,325
20. dbaSQL 9,815
21. Yveau 9,700
22. JimFive 8,375
23. TheLearn... 7,830
24. dbbishop 7,800
25. jimpen 7,275

1. acperkins 371,565
2. nmcdermaid 195,429
3. angelIII 181,551
4. arbert 149,684
5. chapmandew 138,810
6. EugeneZ 87,040
7. matthews... 56,804
8. cs97jjm3 54,849
9. aneeshatti... 47,999
10. mark_wills 44,585
11. rboyd56 42,625
12. PedroCGD 40,880
13. ptjcb 38,638
14. brejk 36,600
15. bhess1 36,130
16. twoboats 30,515
17. frankytee 30,441
18. dready 30,430
19. Yveau 30,000
20. Sirees 27,902
21. jltoops 27,275
22. Lowfatsp... 24,059
23. TommyTupa 23,000
24. gbshahaq 22,472
25. ScottPletc... 22,430

Remove part of string in SQL Database

Asked by NursingCorp in MS SQL DTS, Databases Miscellaneous, SQL Server 2005

Tags: Microsoft, SQL, 2005

About this solution