Cycle Replace within Column

[CGill]

I have a column in a table which stores dates at certain points these dates have corrupted and been replaced by "-" does anyone have a piece of code which will run through only the one column of the table and replace the "-" with a blank string " ".

This will need to work on different tables and cycle through circa 250000 records in each table.

Thanks for any help.

 

[PHV]

Something like this ?
DoCmd.RunSQL "UPDATE theTable SET theColumn='' WHERE theColumn='-';"

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244