>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
Change query to look like this:

TEXT TO lcSQL NOSHOW
     Select *
            from invoices
            where invoices.ccustnum Like ?p_custnumparameter and
                  (p_datetimeparameter IS NULL OR invoices.ddatetimefield = ?p_datetimeparameter)
ENDTEXT
sqlexec(lnconnection,lcSQL,"v_myresult")

*** If you want customer info about particular Date:
p_custnumparameter = XXXXXXX
p_datetimeparameter = '20060929'
sqlexec(lnconnection,lcSQL,"v_myresult")

*** If you want ALL customer info regardless of date:
p_custnumparameter = XXXXXXX
p_datetimeparameter = NULL
sqlexec(lnconnection,lcSQL,"v_myresult")