Darryl,

>Unfortunately the item field has got data with quotes around it. IE
>"KP-00310". I need to clean up the data and have the field contain
>just KP-00310. Since I have 10,000 records, I need a update
>statement or something to clean that up.


To remove all double quotes: UPDATE tablename SET item=REPLACE(item,'"','');

PB

-----


Darryl Hoar wrote:
Greetings,
I have a table in my database called item.  It has two fields: item and
description.

Unfortunately the item field has got data with quotes around it. IE
"KP-00310".  I
need to clean up the data and have the field contain just KP-00310.  Since I
have
10,000 records, I need a update statement or something to clean that up.

Any ideas ?

thanks,
Darryl