Closed Thread
Results 1 to 3 of 3

Hybrid View

  1. 06-19-2003 09:11 AM #1
    Naeem
    Naeem is offline Junior Member
    Join Date
    Apr 2001
    Posts
    99

    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. 06-19-2003 09:32 AM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    UPDATE table SET col = REPLACE(col,' '); will eliminate all spaces.
  3. 06-19-2003 09:37 AM #3
    Naeem
    Naeem is offline Junior Member
    Join Date
    Apr 2001
    Posts
    99
    Thanks it works,
    Sometimes it is better to think simple.
    Naeem
« Previous Thread | Next Thread »

Bookmarks

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

 Click Here to Expand Forum to Full Width