What is the correct syntax for recordset filter option when field value to filter is char, number and also when it is date.<BR><BR>I&#039;ve done it as per the book but not getting it right. I also check the field value with response.write objRS("coName") - but it is showing blank. But the RS does have records fulfilling that criteria.<BR><BR>Also is it possible to use a variable as the filter criteria i.e. objRS.Filter="coID=varname" where variable varname contains a numeric value<BR><BR>Thanks in advance.