String function for update query?

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

Windows XP, MS Access 2K
========================

Is there a "strip" function I can use in an Update query
to get rid of a certain character? I have a text field
called "phoneNumber" and the existing value is in the
format "123-456-7890". I'd like to replace it
with "1234567890".

Thanks!

-Amit
 
Windows XP, MS Access 2K
========================

Is there a "strip" function I can use in an Update query
to get rid of a certain character? I have a text field
called "phoneNumber" and the existing value is in the
format "123-456-7890". I'd like to replace it
with "1234567890".

Thanks!

-Amit
Click to expand...

In Access 2002 yiou can use the Replace() function.
Exp:Replace([FieldName],"-","")
 
Back
Top