Businesses Address not Showing in Business Form

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.

Click on Data in the top left of the screen.
Click on Queries
Click on the Immediate tab.
Paste in the code below.
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

Crows Nest Knowledge Base

Businesses Address not Showing in Business Form

Analytics

Related content