Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace Commas

Status
Not open for further replies.
rekhatr10

rekhatr10

Programmer
Apr 2, 2004
67
0
0
US
SQL server 2000

How can I replace commas if the commas are in between
Ex
I & D, COMPLEX/MULTIPLE
CLOSED RX, RADIAL/ULNAR S
TREATMENT OF FINGER FX, E
Any suggestions
Thank you in advance
Rekha

 
Sort by date Sort by votes
Code: 
select REPLACE('TREATMENT, OF, FINGER, FX, E',',','')

[bandito] [blue]DBomrrsm[/blue] [bandito]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

appelq
  • Locked
  • Question
SQL Server 2012 Bulk Insert CSV File where a column (Cust Name) May have commas 1
Replies
7
Views
134
appelq
appelq
Webkins
  • Locked
  • Question
Need to replace FTP with a SQL Server stored procedure... 1
Replies
2
Views
43
johnherman
johnherman
Molkas
  • Locked
  • Question
Replace multiple values on a string with data from another table
Replies
4
Views
23
fredericofonseca
fredericofonseca
earljgray
  • Locked
  • Question
Replace NULL in a SELECT
Replies
4
Views
78
philhege
philhege
bonjourno
  • Locked
  • Question
Replace function doesn't work when I cross reference 2 tables
Replies
4
Views
73
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top