JCapper Message Board

JCapper 101
-- Outside X Rails

Home	Register Log In

Outside X Rails

dvlander
9/28/2017
1:35:46 PM

Hi Jeff and fellow jcapper fans. I was a jcapper user until about five years ago when career and family issues ruled it out for a while. Now I'm retired and happily married and looking forward to some SQL jcapper entertainment.

Jeff, I searched the board for this question and ended up with some fascinating reading on many entertaining topics but not the specific question I was after. Is there a way to eliminate the 2 outside rail positions in SQL regardless of field size?

I'm having a blast and my old UDMs are performing okay.

Dale

jeff
9/29/2017
10:38:26 AM

Suppose you have a rankF20=1 UDM, and from there you want to, as you put it: "eliminate the 2 outside rail positions in SQL regardless of field size."

Easy to do if you use RailPosition with FieldSize and a little math.

Something like the following should work:

SELECT * FROM STARTERHISTORY
WHERE RANKF20 = 1
AND RAILPOSITION < (FIELDSIZE - 1)

Or, alternately:

SELECT * FROM STARTERHISTORY
WHERE RANKF20 = 1
AND NOT RAILPOSITION >= (FIELDSIZE - 1)

-jp

.

dvlander
9/29/2017
1:38:45 PM

Wonderful sir, I thank you.

JCapper Message Board

JCapper 101 -- Outside X Rails

JCapper 101
-- Outside X Rails