Ado Recordset Filtering problem
in Visaual basic,Using Ado 2.8 and SqlServer2000 , i am trying to filter numeric data. but it is not filtering. the syntax i used was
Rs.filter="Price like %200%"
in the result set i need to see all the "Price" which contains "200". Pls note that Datatype of the field "Price" is NUMERIC(Float) in the database.