Delete record (part)

[Guest]

I hv thousand of records in one field which look like this 2006-10-0001-01.

How to delete - (dash) without changing other number.

Thanks

 

[Guest]

Hi Zyus,

If you are using Access 2000 or later, you can use the built-in Replace
function. Create a new update query. Add the field with this data into the
QBE grid. In the Update To: row, enter:

Replace([FieldName]), "-", "")

where FieldName is the name of the field.

Note: It's always a good idea to make a back-up copy of your database before
running any action query, just in case things don't turn out as expected.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I hv thousand of records in one field which look like this 2006-10-0001-01.

How to delete - (dash) without changing other number.

Thanks