|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Graded stakes | |
| slowkey 11/1/2011 2:40:36 AM | I have a problem with sql. If I make the following statement: Where CLASSDESCRIPTOR = 'G' It can also be And Classdesriptor = 'G' I get know G races. I also tried AND INSTR('N-G', CLASSDESCRIPTOR) > 0 This gives me N races but no G races. I have to use a work around like the following to get results but searches take for ever. AND INSTR('C-M-A-S-A-AO-T-CO-R', CLASSDESCRIPTOR) = 0 AND PURSE >= 75000 I have to add the purse qualification to get rid of the * or other races. Neither the * Or G is working for me. With the work around I do get my G and N races. Strange. Any help appreciated. I am trying to make some Breeders Cup UDM's. If I do a sql All statement with class descriptor selected I can see that I have plenty of stake races in the data base coming up G. Probably something simple that is wrong here but cannot figure this out.
| |
| STUBALL 11/1/2011 10:35:04 AM | I will tell you what I do and it works.. AND INSTR('G1-G2-G3', CLASSDESCRIPTOR) > 0 I think it will work fine. Stuball
| |
| slowkey 11/1/2011 2:40:05 PM | I knew it was something simple. Thanks Doug
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |