Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Outside X Rails

Home Register
Log In
By 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

Reply
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

.

Reply
dvlander
9/29/2017
1:38:45 PM
Wonderful sir, I thank you.

Reply
Reply

Copyright 2008 JCapper Software              back to the JCapper Message Board              www.JCapper.com