Hi, can anyone fix the space problem in my sql statement? I am getting this error message:

ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

This is my sql statement:
sql = "SELECT * FROM " & tblname & " WHERE " &Col& " = N'" &Var& "' AND [Show]=1 ORDER BY [Code] ASC"

And I am passing the parameters to the url something like this:
Product.asp?Visit=Yes&Var=Hong%20-%20Kong&Col=Place

Problem is that most of my data contain a space (eg. Hong Kong).

I don't have this error when my data is single word (eg. Sydney)

Please help!!