eliminate comma from string

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • scottichrosaviakosmos
    New Member
    • Aug 2008
    • 2

    eliminate comma from string

    I have a table in sql server which is populated from oracle table . For this import i am using ssis . now I have columns of first name and last name . In these columns the data is not going in proper manner. This is because Some data is comming with ","(comma) in beween strings. exmp: lastname='Mor,g an' .
    I want to get out of this. I want my data to be inserted in proper format.
    If any commas in between or in last or in start of the string then it will eliminate it and insert corrected data to sql server.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    You can use the replace function to replace the commas with a blank string.

    Comment

    Working...