format phone numbers

Results 1 to 2 of 2

Thread: format phone numbers

  1. #1
    Join Date
    Dec 1969

    Default format phone numbers

    i need to format the phone number before storing them in sql server.the format should be xxx-xxx-xxxx.User will be entering xxxxxxxxxx.<BR>any help appreciated

  2. #2
    Join Date
    Dec 1969

    Default RE: format phone numbers

    Check out Left(), Mid(), and Right().

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts