Only pull numbers our of field

• jordon.shaw

  Hall of Fame

  Points: 3571

  More actions

  July 27, 2010 at 3:56 pm

  #235701

  I have a phone number field. The data in it is formatted as xxx-xxx-xxxx; however, I have a need to query that without the dashes, so I only want to pull xxxxxxxxxx. Is this possible?

  Thanks,

  Jordon

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  July 27, 2010 at 4:52 pm

  #1199031

  Take a look at REPLACE.

  REPLACE (string_expression,string_pattern,string_replacement)

  select replace(phone_num, '-','')

  ---

  And then again, I might be wrong ...
  David Webb