<% if request.form("Submit") = "Submit" Then if request.form("City") = "%" then sqlc = "Select * from [Diplomates] where lastName like '" & request.form("name") & "%' and Country like '" & request.form("Country") & "' and State like '" & request.form("State") & "' order by LastName, FirstName" else sqla = "Select * from [Diplomates] where lastName like '" & request.form("name") & "%' and Country like '" & request.form("Country") & "' and State like '" & request.form("State") & "' and City like '" & request.form("City") & "' order by LastName, FirstName" sqlc = sqla & " union Select * from [Diplomates] where lastName like '" & request.form("name") & "%' and Country like '" & request.form("Country") & "' and State like '" & request.form("State") & "' and City like '" & request.form("City") & "' order by LastName, FirstName" end if Set RSc = datab.Execute(SQLc) if RSc.eof then %> There are no matches to your request please try again.

<%else%> <% RSc.movefirst %> <%while not RSc.eof %> <%=RSc("LastName")%>  <% if trim(RSc("Suffix") & "") = "" then response.write " "%> <%else%> <%=RSc("Suffix")%>,  <%end if%> <%=RSc("MDorDO")%>, <%=RSc("FirstName")%> <% if trim(RSc("ActiveOrRetired")) = "R" then response.write " (Retired)"%> <%else response.write "" end if%>
<% if trim(RSc("City") & "") = "" then response.write " "%> <%else%> City: <%=RSc("City")%>
<%end if%> <% if trim(RSc("State") & "") = "" then response.write " "%> <%else%> State: <%=RSc("State")%>
<%end if%> <% if trim(RSc("Country") & "") = "" then response.write " "%> <%else%> Country: <%=RSc("Country")%>
<%end if%>
<% RSc.movenext Wend%> <%if not isempty(RSc) then response.write " " end if end if%> <%End if %>
We invite you to use the below search engine to locate doctors by Country, State, City or typing last name. To begin your search, please be sure to press the "Submit" button instead of using the "Enter" key on your keyboard. 

Country:	All Countries <%SQLa = "Select Distinct (Country) from [Diplomates]" Set RSa = datab.Execute(SQLa) While not RSa.eof %> "><%=RSa("Country")%> <%rsa.movenext Wend%>
State:	All States <% SQLab = "Select Distinct (State) from [Diplomates]" Set RSab = datab.Execute(SQLab) While not RSab.eof %> "><%=RSab("State")%> <%RSab.movenext Wend%>
City:	All Cities <%SQLac = "Select Distinct (City) from [Diplomates]" Set RSac = datab.Execute(SQLac) While not RSac.eof %> "><%=RSac("City")%> <%RSac.movenext Wend%>
Last Name:

The listings are not meant to be used for official verification purposes. Visit the Official Verification Information page for information on obtaining a verification of certification.

Home | Directory of Diplomates | History of the Specialty Board | Definition of a Board Certified Colon & Rectal Surgeon
Residency Programs | Certification | Recertification | Future Exam Dates | Board of Directors
Future Meeting Dates | Staff Directory | Program Directors Association
Related Organizations | Brochure Orders | Address Change Form

Copyright © 2000 by The American Board of Colon and Rectal Surgery. All Rights Reserved.
20600 Eureka Road, Suite 600 • Taylor, MI 48180
Phone: (734) 282-9400 • Fax: (734) 282-9402 • E-Mail: admin@abcrs.org