I am using VB 6 with ADO to query a MS SQL database. I need to return all the records which match my criteria. I can explain it in words but not in code.
Verbally, here is what I am trying to do with a field called ItemNo.
I am given ItemNo = 415.
The table contains 415, ?15, ??5, 4?6, 4?9...