Bob WildermuthGalloway, Murray & Scheetz | 574-721-01981231 E Broadway
Logansport, IN
|  |
|
| Bob Wildermuth | 1231 E Broadway | Logansport | 574-721-0198 | wilderone3@yahoo.com | Galloway, Murray & Scheetz | 384532838 | | 25130 |
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" = '384532838' or Replace("Agent Logon Name",'RA','') = '384532838'