Remove Space from table records

mateenmohd · July 20th, 2003, 06:49 AM

Hi,

How can remove the spaces from the table's records ?
Which is save in sql server database
I have thousand of records which image name are save like this.

Contract no20 location a.tif
Contract no25 location b.tif
Contract no26 location c.tif
And so onâ¦â¦.

It create problem in display the image.
Which query will use to remove the spaces of records which are save in sql server ?
Please help.

Mateen
[email protected]

Jeff Mason · July 20th, 2003, 06:55 AM

Code:

UPDATE YourTable SET YourColumn=REPLACE(YourColumn,' ','');

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com