April 01, 2020, 02:47 PM
JacksonvilleHow 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