I want to convert some data like this in a query
0K9F-5-L-997-01 >>> 0K9F5L99701
4W7Y-0-99-99-99 >>> 4W7Y0999999
I use replace fuction, but it not works and show error!
man_code: Replace([item_code],"-","")
It is the replace fuction not works in access?
How can I fix this problem?