Advertisement
DataCCIW

Reverse Address Link

Jan 7th, 2020
656
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.29 KB | None | 0 0
  1. SELECT
  2. CASE
  3.     WHEN (LEN(dbo.core_funct_family_members(m.person_id))) > 0
  4.         THEN dbo.core_funct_family_members(m.person_id)
  5.     ELSE '<a href="https://www.whitepages.com/address/' + street_address_1 + '/' + postal_code + '" target="_blank">(Reverse Address Search)</a>'
  6. END  [Family Members]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement