I am trying to query a sql server table using the following:

sqlexec(lnconnection,"Select * from invoices where invoices.ccustnum Like ?p_custnumparameter and invoices.ddatetimefield Like ?p_datetimeparameter","v_myresult")

if I enter a date it returns the proper results, if I enter % (wildcard) I get no results

I need to get all records for a customer regardless of date not only records for a specific date