/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [GALACTICID]
      ,[LOCID]
      ,[NAME]
      ,[SEARCHNAME]
      ,[ABBREVNAME]
      ,[PRIMPHONE]
      ,[SECPHONE]
      ,[FAXPHONE]
      ,[EMAIL]
      ,[CONTACTBY]
      ,[CONTACT]
      ,[ADDRESS1]
      ,[ADDRESS2]
      ,[CITY]
      ,[STATE]
      ,[ZIP]
      ,[COUNTRY]
      ,[PARENTID]
      ,[NETREPORTPATH]
      ,[NOTEMARGINS]
      ,[HANDOUTMARGINS]
      ,[LETTERMARGINS]
      ,[STATUS]
      ,[GENPROP]
      ,[FAXDEVICE]
      ,[DB_CREATE_DATE]
      ,[DB_UPDATED_DATE]
      ,[FAXACCOUNT]
      ,[CHARTROOM]
      ,[DEPTH]
      ,[PATH]
  FROM [centricity_emr].[peek].[LOCREG]
  WHERE (NAME LIKE '%latin%') OR (NAME LIKE '%general ped%') OR (NAME LIKE '%adol%')