Results 1 to 5 of 5

Thread: [RESOLVED] trying to replace a symbol dosnt work why?

  1. #1

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Resolved [RESOLVED] trying to replace a symbol dosnt work why?

    i have this phone numbers witch contains this symbole (-)
    exapmle
    Code:
    052-9646312
    056-9972161
    i want to remove this(-)
    tried this code to run in access query it dosnt work.
    nothing is changing.
    Code:
    UPDATE Customers SET Customers.Cellular = Replace('-','')
    tnx for any help
    salsa

  2. #2
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    5,872

    Re: trying to replace a symbol dosnt work why?

    The replace function also needs an input string
    https://support.microsoft.com/en-us/...8-e0a4ef67d181

    Maybe something like this:
    Code:
    UPDATE Customers SET Customers.Cellular = Replace(Customers.Cellular, '-', '')

  3. #3

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: trying to replace a symbol dosnt work why?

    Quote Originally Posted by Arnoutdv View Post
    The replace function also needs an input string
    https://support.microsoft.com/en-us/...8-e0a4ef67d181

    Maybe something like this:
    Code:
    UPDATE Customers SET Customers.Cellular = Replace(Customers.Cellular, '-', '')
    thank you

  4. #4
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: [RESOLVED] trying to replace a symbol dosnt work why?

    Why are you asking a question that is 100% about SQL in the VB.NET forum? This site has a Database Development forum. That's where SQL questions belong.

  5. #5
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: [RESOLVED] trying to replace a symbol dosnt work why?

    Thread moved to the 'Database Development' forum

Posting Permissions

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



Click Here to Expand Forum to Full Width