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?
:confused:

UPDATE table SET col = REPLACE(col,' '); will eliminate all spaces.

Thanks it works,
Sometimes it is better to think simple.