Link to home
Start Free TrialLog in
Avatar of zachvaldez
zachvaldezFlag for United States of America

asked on

Comparing string

Format phone number
In one table , phone number is in this format (999)999-9999 while in another table the phone display as (999) 999-9999. notice the extra space.
I could not compare both numbers. What's the solution
SOLUTION
Avatar of Dean Chafee
Dean Chafee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of zachvaldez

ASKER

How about creating 2 columns with same format?
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for your help guys!