Oct 9, 2002 #1 yld53x Programmer Oct 9, 2002 8 0 0 AU hi i'm importing a table with phone numbers (home and mobile) eg (07) 555555 and (0412) 00000. in design query how can i get rid of the () and leave it at 07555555 and 041200000. thanks
hi i'm importing a table with phone numbers (home and mobile) eg (07) 555555 and (0412) 00000. in design query how can i get rid of the () and leave it at 07555555 and 041200000. thanks
Oct 9, 2002 #2 r937 Technical User Jun 30, 2002 8,847 0 0 CA update yourtable set phonenumber = replace(replace(phonenumber,')',''),'(','') where phonenumber like '*[()]*' rudy Upvote 0 Downvote
update yourtable set phonenumber = replace(replace(phonenumber,')',''),'(','') where phonenumber like '*[()]*' rudy