JCapper Message Board

JCapper 101
-- SQL Expression to pick up Allowance Optional Claiming?

Home	Register Log In

SQL Expression to pick up Allowance Optional Claiming?

notchback
12/19/2010
10:33:09 PM

I am using the following expression:

SELECT * FROM STARTERHISTORY
WHERE INSTR('AO', CLASSDESCRIPTOR) > 0

The problem is that it picks up Allowance races as well. Is there a way to write it to ONLY pick up AO races?

Thanks,

Doug

notchback
12/19/2010
10:35:46 PM

A follow up question. When I run the following expression:

SELECT * FROM STARTERHISTORY
WHERE INSTR('G', CLASSDESCRIPTOR) > 0

I get back 0 races for graded stakes. If I run all classes through my starter history table there are graded stakes listed.

Doug

STUBALL
12/20/2010
9:37:02 AM

this will get you only AO races

AND INSTR('AO',CLASSDESCRIPTOR) > 0
AND INSTR('A',CLASSDESCRIPTOR) = 0

Stuball

STUBALL
12/20/2010
9:41:37 AM

to get all graded races use this

AND INSTR('G1-G2-G3',CLASSDESCRIPTOR) > 0

notchback
12/20/2010
11:17:18 AM

Thanks! Perfect. Appreciate the help.

Doug

JCapper Message Board

JCapper 101 -- SQL Expression to pick up Allowance Optional Claiming?

JCapper 101
-- SQL Expression to pick up Allowance Optional Claiming?