DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Eliminate space between two charecters

  1. #1
    Join Date
    Apr 2001
    Posts
    103

    Eliminate space between two charecters

    Hi,

    I have a column with the a value something like this
    3 NBS 75.
    Is there a way to eliminate the space between the charecters?
    Naeem

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    UPDATE table SET col = REPLACE(col,' '); will eliminate all spaces.

  3. #3
    Join Date
    Apr 2001
    Posts
    103
    Thanks it works,
    Sometimes it is better to think simple.
    Naeem

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