JCapper Message Board

JCapper 101
-- SQL MSPW TO MCLM and PURSE

Home	Register Log In

SQL MSPW TO MCLM and PURSE

GUGA
6/5/2010
12:10:54 PM

Would this be the correct sql expression for capturing horses dropping from maiden special last to maiden claiming today????

SELECT * FROM STARTERHISTORY
WHERE INSTR ('S' , CLASSDESCRLAST) > 0
AND INSTR ('M' , CLASSDESCRIPTOR) > 0

Also, can I use an "or" statement to include purse droppers or same level??..ie I want to exclude purse risers. or possibly a not equal to statement?

Thanks in advance Scott.

~Edited by: GUGA on: 6/5/2010 at: 12:09:51 PM~

~Edited by: GUGA on: 6/5/2010 at: 12:10:22 PM~

~Edited by: GUGA on: 6/5/2010 at: 12:10:54 PM~

STUBALL
6/5/2010
12:51:18 PM

I would add
AND CLSHIFT = 2
to include purse droppers
AND CLSHIFT = 0 for purse no change...
INSTR('0-2',CLSHIFT) to include both

Stuball

~Edited by: STUBALL on: 6/5/2010 at: 12:51:18 PM~

jeff
6/5/2010
1:54:18 PM

--quote:

"Would this be the correct sql expression for capturing horses dropping from maiden special last to maiden claiming today????

SELECT * FROM STARTERHISTORY
WHERE INSTR ('S' , CLASSDESCRLAST) > 0
AND INSTR ('M' , CLASSDESCRIPTOR) > 0

Also... I want to exclude purse risers....

Thanks in advance Scott."

--end quote

Scott. Yes. The sql expression you posted will get horses dropping from MdSplwt last start into MdClm today.

If you want to exclude class risers (as defined by change in purse value) just add the following line to your expression:

AND NOT CLSHIFT = 1

-jp

.

GUGA
6/5/2010
9:07:49 PM

Thanks to both of you gentlemen for the assistance. It is greatly appreciated!

JCapper Message Board

JCapper 101 -- SQL MSPW TO MCLM and PURSE

JCapper 101
-- SQL MSPW TO MCLM and PURSE