Deleting a single character in a text field

M

ma1000

In one of my tables i have a field that has a text values like '123.23123' i
would like , to delete the full stop. How can i do this. I cant do it in
excel as the number of records that i have is over 200000.
 
S

Stefan Hoffmann

hi,
In one of my tables i have a field that has a text values like '123.23123' i
would like , to delete the full stop. How can i do this. I cant do it in
excel as the number of records that i have is over 200000.
Click to expand...
Create a update query, use

Replace([yourField], ".", "")

as new value.


mfG
--> stefan <--
 
Top