Using excel 2003
I'm trying to return a recordset using the 'LIKE' operator. In the example below, strFilter is a textbox value.
rs.Open "SELECT * FROM qryAccountSetup WHERE ProgramTypeId = " & intId & " AND (AccountNo Like '" & strFilter & "') ORDER BY AccountNo", co, adOpenForwardOnly, adLockReadOnly
If strFilter = '00001' then a value is returned from the recordset.
If strFilter = '0000*' then the recordset is empty.
What is the correct syntax when using 'LIKE'?
Can anyone help please?
Thanks in advance,