Businesses Address not Showing in Business Form

Owned by Timothy Hitchcock
Last updated: Nov 15, 2021 by Mike Nelson (Unlicensed)
1 min read

Using the excel import template to add businesses causes the address not to show in the business form.
This article will show you how to get the addresses to show for these imported businesses.

  1. Click on Data in the top left of the screen.

  2. Click on Queries

  3. Click on the Immediate tab.

  4. Paste in the code below.

  5. Click Execute

 

UPDATE dbo.Business SET AddressFull = CONCAT_WS(CHAR(10) + CHAR(13), ScreenDescription, Address1, Address2, Address3,   ISNULL(CASE WHEN City IS NOT NULL AND [State] IS NOT NULL THEN CONCAT(City, ', ', [State])   WHEN City IS NOT NULL THEN City   WHEN [State] IS NOT NULL THEN [State] END, '') +   ISNULL(CASE WHEN City IS NOT NULL OR [State] IS NOT NULL THEN '  ' + Zip   ELSE Zip END, '')   ) FROM Business WHERE AddressFull IS NULL

 




Â