expression where data is the same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

for example i have a phone number field and an 800 phone number field
phone 800 phone expression
800-571-1234 800-571-1234 800-571-1234
717-234-5678 800-231-1234

i just want to pull the ones that are the same in an expression
 
Try this

Select [phone], [800 phone] , iif([phone] = [800 phone],[800 phone],"") as
expression From TableName
 
Back
Top