|| run style
|What is the proper syntax for runstyle in SQL?|
I want my results to E or EP.
|runstyle number integer running style (1=E, 2=EP, 3=P, 4=S, 5=NA)|
|This older thread contains some posted examples:|
|For HDW Data:|
Min val for the E run styles is 0
Min val for the EP run styles is 15
Min val for the P run styles is 30
Min val for the PS run styles is 45
Min val for the S run styles is 60
Min val for the SS run styles is 75
Min val for the U run styles is 90
"I want my results to E or EP."
From the HDW run style table (above) the E and EP run styles are all in the min val=0 to max val < 30 range.
One way to reference E and EP runs styles in a sql expression would be like this:
AND RUNSTYLE >= 0 AND RUNSTYLE < 30
Another (simpler) way would be:
AND RUNSTYLE < 30
Both will work.