I want to find out if there is a match, case notwithstanding for a first name, last name, gender. It is my understanding that this will look at "Bob" and "BOB" as different names. Yes? If not please let know what a better approach for doing this would be.
bPartFound = False
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT RosterID FROM Roster WHERE FirstName = '" & field1 & "' AND LastName = '" & field2 & "' AND Gender = '" & field3
sql = sql & "' AND TeamsID = " & lTeamID
rs.Open sql, conn, 1, 2
If rs.RecordCount > 0 Then bPartFound = True
Set rs = Nothing