Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. SELECT Contact.Id
  2. FROM Contact
  3. INNER JOIN Phone ON Phone.ContactId = Contact.Id AND CONTAINS(Phone.Number, '"519-777*"')
  4. WHERE Contact.Deleted = 0 AND Contact.CompanyId = 237
  5.  
  6. SELECT Contact.Id
  7. FROM Contact
  8. INNER JOIN Phone ON Phone.ContactId = Contact.Id AND Phone.Number LIKE '519-777%'
  9. WHERE Contact.Deleted = 0 AND Contact.CompanyId = 237
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement