|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | NO Girls | |
| parshooter 10/3/2010 11:08:16 PM | I am curious if anyone has constructed a negative SQL UDM that identifies fillies/mares running against males. I am having trouble with restricting appropriate races. Any suggestions would be appreciated. ~Edited by: parshooter on: 10/3/2010 at: 11:08:16 PM~
| |
| ryesteve 10/4/2010 10:08:33 AM | I've never done it, but you would have to use the AgeSexCode field... the third character denotes the race's gender restrictions, so you'd have to use a SQL string function... and then compare that to the horse's gender designation. In other words, something like: if gender in ('F' 'M') and substr(agesexcode,3,1) not in ('F' 'M') to flag females running in open races. (FYI, that is not necessarily proper SQL syntax)
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |