Thanks a lot Merrill is just that i need.

Is working fine.

I have a table and i need to delete the blanks in records like this

serialnumber = 'SGS04437PA         '

but I dont want to update all the records, is possible to know...