jcgapps

Create SQL command to filter records

Discussion created by jcgapps on May 19, 2017
Latest reply on May 19, 2017 by user1069

I need an example of selecting records using a SQL query with WHERE clause.

 

The where clause can be dynamic depending on the user criteria entry.

For example, the user can select CATEGORY criteria three times so I can have this string:

 

WHERE CATEGORY IN ('DRESS','PRINT','GENERIC')

 

Thanks.

Outcomes