String manipulation

• jenniferhu46

  SSCrazy

  Points: 2990

  More actions

  May 30, 2006 at 9:03 am

  #169079

  Hi all,

     I have an address column in database, and I need to output this address column to only string without ',' and '#'. 

  How to use replace (address,.....) to eliminate 2 characters?

  Thank you.

• stax68

  SSChampion

  Points: 11711

  More actions

  May 30, 2006 at 9:04 am

  #640712

  replace(replace(@str,',',''),'#','')

  Tim Wilkinson

  "If it doesn't work in practice, you're using the wrong theory"
  - Immanuel Kant

• Prakash Sawant

  SSCrazy

  Points: 2173

  More actions

  May 31, 2006 at 2:30 am

  #640846

  SELECT replace(replace(Address,',',''),'#','') AS Address FROM <TABLE_NAME>

   

  ------------
  Prakash Sawant

  http://psawant.blogspot.com