Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Contact.Id
- FROM Contact
- INNER JOIN Phone ON Phone.ContactId = Contact.Id AND CONTAINS(Phone.Number, '"519-777*"')
- WHERE Contact.Deleted = 0 AND Contact.CompanyId = 237
- SELECT Contact.Id
- FROM Contact
- INNER JOIN Phone ON Phone.ContactId = Contact.Id AND Phone.Number LIKE '519-777%'
- WHERE Contact.Deleted = 0 AND Contact.CompanyId = 237
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement