I replied a question today about how to use LIKE with parameters in Access (OleDbCommand). Say you have a table TABLE1 setup like this: ID AutoNumber Name Text and populated with dummy data 1 Teemu 2 Mike 3 Mark And you want to have a LIKE match to name.