Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Surface switch

Home Register
Log In
By Surface switch
GUGA
6/17/2012
11:24:29 AM		Anyone out there know how to setup a sql expression to capture horses switching from dirt to turf or vice versa?

Reply
jeff
6/17/2012
12:16:58 PM		surface switch: turf-to-dirt

For reference/background info, see the factor named surfaceshift at the supported factors page at JCapper.com:
http://www.jcapper.com/factorsglossary.asp

Turf to dirt (from the chart at the above link) is 4 through 7. The field name in the table schema is sfshift. Adding the following line to a sql expression will make the expression flag turf to dirt horses:

AND SFSHIFT BETWEEN 4 AND 7

Alternately, you could use something like the following 2 lines:

AND SFSHIFT >= 4
AND SFSHIFT <= 7




dirt-to-turf

Dirt to turf (from the chart at the above link) is 8 through 11. The field name in the table schema is sfshift. Adding the following line to a sql expression will make the expression flag dirt to turf horses:

AND SFSHIFT BETWEEN 8 AND 11

Alternately, you could use something like the following 2 lines:

AND SFSHIFT >= 8
AND SFSHIFT <= 11



-jp

.

Reply
GUGA
6/17/2012
6:02:53 PM		Thanks Jeff!

Reply
Reply
Copyright © 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com