>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
George Simon, MCP