Hi Mark,

In yor SQL-SELECT statement, you could set up the WHERE clause like this:

WHERE table.category LIKE ?lcCategory

Then when you want to include all categories do the following:

lcCategory = '%'

I am assuming by your variable notation that lcCategory is a charactor data type.

HTH