Hi Richard:

I feel so stupid. Here is my code for searching. I have tried the ORDER BY clause in every location imaginable and can't figure it out.

<%
Surname = request("Surname")
GivenName = request("GivenName")


WhereStr = ""
if Surname <> "" then
WhereStr = WhereStr & "Surname LIKE '" & Surname & "%'"
end if
if GivenName <> "" then
if WhereStr <> "" then
WhereStr = WhereStr & " AND "
end if
WhereStr = WhereStr & "GivenName LIKE '" & GivenName & "%'"
end if

If WhereStr <> "" then
WhereStr = "WHERE " & WhereStr

end if
SQL = "SELECT * FROM CustomerT" & WhereStr
%>