Standard Loaded -
Security - Edit Roles set to
Security - Add Roles set to
Security - Delete Roles set to
Standard Alternate Loaded -
Executed SQL - select dbo.Propercase("Agent First Name" + ' ' + "Agent Last Name") as Name, "Agent Address Street Name" as Address, "Agent City" as City,
/*'(' + Cast("Agent Phone1 Area Code" as varchar(900)) + ') ' +
Left(Cast("Agent Phone1 Number" as varchar(900)),3) + '-' + Right(Cast("Agent Phone1 Number" as varchar(900)),4)*/ "Agent Phone1 Number" as Phone, "Agent Email" as Email,
dbo.ProperCase("AOOffice Name") as broker,
Replace("Agent Logon Name",'RA','') as NRDS,
"Agent Url" as url, "Agent Identifier" as AgentID
from mlsData.dbo.irmls_agt
Where "Agent Logon Name" = '0' or Replace("Agent Logon Name",'RA','') = '0'