How to remove multiple symbols from a field

  • Thread starter Thread starter tsraj
  • Start date Start date
T

tsraj

Please suggest a query to remove multiple symbols (, . #) from a field. I
was able to use the Replace function to remove one symbol and not multiple.
Ex: Ven: Replace([VendorName],","," "). This replaced the comma with a
space. I like to remove the period with a space.

Any suggestion?
 
Back
Top