Format field by inserting characters

• dotnetdns

  Valued Member

  Points: 74

  More actions

  July 1, 2008 at 6:45 am

  #71665

  I need to use QA to format a field (char, 14) of phone numbers to insert brackets around the area code:

  current field value:

  4075551212

  new field value:

  (407)5551212

  Thanks for taking a look,

  Doug

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  July 1, 2008 at 7:32 am

  #836671

  dotnetdns (7/1/2008)

  ---

  I need to use QA to format a field (char, 14) of phone numbers to insert brackets around the area code:

  current field value:

  4075551212

  new field value:

  (407)5551212

  Thanks for taking a look,

  Doug

  Check out this link:

  http://www.sqlservercentral.com/articles/Administering/usingcheckconstraints/815/