Replace Function - ISO Alternative

C

cynteeuh

I use the below statement in a query to extract an extension from a phone
number that is stored as (504) 123-4567. However, the "replace" function
seems to be preventing me from sharing this query with another application
via odbc. Is there another way write the below without the replace function?

Ext: IIf([StudioId]="EAC","1" &
Right([PhoneNumber],4),IIf([StudioId]="EAUK",Right([PhoneNumber],5),Replace(Right([PhoneNumber],6),"-","")))

Thanks in advance for your help!
 

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

Replact function - Alternative 4
Format Phone in Query Expression 2
mailmerge with access 1
"too few parameters expected" when filtering OpenRecordset 2

Top