Results 1 to 3 of 3

Thread: Changing Data

  1. 04-26-2004, 02:10 AM #1
    kenaroo
    kenaroo is offline Registered User
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    2

    Changing Data

    Can someone please help me with the following. I want to change the contents of a field containing phone numbers, the field is varchar(20) and contains data such as XX-XXXX XXXX, what I want to do is remove the '-' so that such a number is displayed as XX XXXX XXXX.
    Reply With Quote Reply With Quote
  2. 04-26-2004, 05:26 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    use REPLACE function
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 04-27-2004, 10:43 PM #3
    kenaroo
    kenaroo is offline Registered User
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    2

    Changing Data

    Thank you, I knew it would be easy, but just couldn't find it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules