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:
Printable View
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.