ive created a simple search statement
SELECT *
FROM tbljobs
WHERE intjobcat LIKE MMColParam OR strdescription LIKE '%MMcolparam2%' AND intjobtype IN (MMcolparam3)

and have set the MMcolparams to be % if the entry from the form is empty however i get invalid SQL statement .. should i be using a different wildcard if the expected mmcolparam is a number ?

What database? (For reference)

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

you cannot use a wildcard character if the field is numeric.

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]