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],"-","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove text from a field 2
Formatting Phone Number 9
Using 'Replace' function in Query 4
Query to replace text specific Charcters 1
How do I format phone number display in Outlook 2003 2
Formula to extract digits from a text string? 7
String Formatting in VB.NET 7
Formatting a Field 2

Back
Top