Format string

• jenniferhu46

  SSCrazy

  Points: 2990

  More actions

  January 16, 2006 at 8:29 am

  #103043

  Hi experts,

  In SQL Server 2000 table, a social security number column is in a format of xxx-xx-xxxx.

  How to retrieve it in a format xxxxxxxxx (get rid of the "-")???

  Thank you.

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  January 16, 2006 at 8:41 am

  #614930

  Uh.  Replace(ssn,'-','') ?

  
  
  Mark