Hello, from reading some posts earlier I came up with this code to use sql to retrieve records. Please tell me what I am doing wrong.

rs.open "Select * From Table1 Where Number = '%" & MyVar1 & "%", ConnectString, adOpenStatic, adLockOptimistic

The MyVar1 is a is a numeric value since the Number field is a numeric value. It does not work however, can someone please help.

Thanks,
Thai