Demonstrate LIST and Conditional Variables

Return to the Net.Data Examples

Condition #1

cust_inp = IBM
prd_inp = 755C

This is the where_clause:

WHERE custid = 'IBM' AND product_name LIKE '755C%'

Condition #2

cust_inp = IBM
prd_inp =

This is the where_clause:

WHERE custid = 'IBM'

Condition #3

cust_inp =
prd_inp =

This is the where_clause: