General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
When using the wildcard %, you need to use the Like operator. The = operator will not work.
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only