Focal Point
How to Create a Program Using Multiple ORs Statements

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7081057331/m/5487000396

April 01, 2020, 02:47 PM
Jacksonville
How to Create a Program Using Multiple ORs Statements
Hi All,
I have a question regarding using multiple ORs statements. Below is my SQL query

DECLARE @INDX AS CHAR(4)
SELECT @INDX = '7P'

SELECT COUNT(DISTINCT FIELD) FROM TABLE
WHERE INDEX01 = @INDX OR INDEX02 = @INDX OR INDEX03 = @INDX OR INDEX04 = @INDX OR INDEX05 = @INDX OR INDEX06 = @INDX OR INDEX07 = @INDX
OR INDEX08 = @INDX OR INDEX09 = @INDX OR INDEX10 = @INDX OR INDEX11 = @INDX OR INDEX12 = @INDX OR INDEX13 = @INDX OR INDEX14 = @INDX
OR INDEX15 = @INDX OR INDEX16 = @INDX OR INDEX17 = @INDX OR INDEX18 = @INDX OR INDEX19 = @INDX OR INDEX20 = @INDX

I don't know how to create a program in WebFocus when using multiple ORs.

Thanks in Advance

Sincerely
Harry