Sorry about that... I saw lcCategory = '%' and thought that was part of the where clause. You are right, I should have taken a closer look.

Thanks for the clarification.....:)

>>When using the wildcard %, you need to use the Like operator. The = operator will not work.
>
>John,
>
>I am using the LIKE operator. Look more closely at my post.
>
>>>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