Simple Query Question

[number6car]

How do you formulate a query for "south" without getting returns "south" and "southeast"?

[June7]

Maybe:

SELECT * FROM table WHERE fieldname="south";

[number6car]

Sorry, I forgot to mention it's from a dropdown list [<option><%=FP_FieldHTML(fp_rs,"TournamentName")% ></option>] and tournament names "xxx south" and "xxx southeast" exist. If you select "xxx south" the results include "xxx south" and "xxx southeast", or of course "xxx north" produces "xxx north" and "xxx northeast" and I'd imagine "xxx northwest" if or when it exists in the table.

[number6car]

This is probably a VBScript question more than an Access question...

[June7]

Where is this code: [<option><%=FP_FieldHTML(fp_rs,"TournamentName")% ></option>]

Why would this be a VBScript question?

Maybe you should tell exactly what you are doing.

[number6car]

See http://tournamenttime.net/Tournaments.asp. If you select a tournament name with south, it will show both south and southeast. If you select southeast it will only display southeast.

[June7]

I don't know much web coding. I certainly don't know how that web page pulls data from Access db. If you need a query analyzed then provide the SQL statement.