> been entered in a number of different formats some containing . or -
> or /. Some with area codes with (). What I want to do is get them all
> the same. Now I can take all the records and get them all in a simple
> 10 digit sequence but I then want to convert them all to (123)456-7890
> format. The field that houses the phone number is a varchar(50) field.
>
Eric,
these two UDF's will do it:
http://www.cflib.org/udf.cfm?ID=707
http://www.cflib.org/udf.cfm?ID=403
Good luck!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
