CODEWITHSUNDEEP
sqlsql-server
Daniel Bailey
Daniel Bailey

Reputation: 115

Replacing multiple items(commas, periods, etc.) in SQL code

Here is the code that I am using currently, I am trying to replace commas and periods in my database but right now it is only doing one or the other. Thanks

(Case when dim.obligorname like '%,%' then Replace(DIM.[ObligorName], ',', ' ') 
           Else case when dim.obligorname like '%.%' then Replace(DIM.[ObligorName], '.', ' ')
            Else Dim.ObligorName end end) as Obligorname,

Upvotes: 0

Views: 196

Answers (2)

BWS
BWS

Reputation: 3846

Why not just try something like this:

UPDATE myTable DIM
  SET DIM.[ObligorName] = 
    Replace(Replace(DIM.[ObligorName], ',', ' '), '.', ' ')

Upvotes: 3

DVT
DVT

Reputation: 3127

How about something like this:

Replace( Replace(DIM.[ObligorName], ',', ' '), '.', ' ')

Upvotes: 2

Related Questions