return recordset using 'Like' Operator

Neal · September 22nd, 2009, 06:56 AM

Using excel 2003

Hi,

I'm trying to return a recordset using the 'LIKE' operator. In the example below, strFilter is a textbox value.

Code:

 
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,

om_prakash · September 22nd, 2009, 07:14 AM

Try using:

Code:

rs.Open "SELECT * FROM qryAccountSetup WHERE ProgramTypeId = " & intId & " AND (AccountNo Like '%" & strFilter & "%') ORDER BY AccountNo", co, adOpenForwardOnly, adLockReadOnly