JCapper Message Board

JCapper 101
-- Trainer Name Match in SQL Mode

Home	Register Log In

Trainer Name Match in SQL Mode

jeff
2/20/2010
2:17:32 PM

From my email inbox...

--quote:

"Hey Jeff,

Any idea why I can't get trainers to work in my sql expressions. Do I have a brain block? I can do riders fine.

SELECT * FROM STARTERHISTORY WHERE TRAINER = 'PLETCHER T'

I get 0's showing for every trainer, but in the playlist file mode I am fine.

Thanks,

DT"

--end quote

My Reply:

'PLETCHER T' is only a partial name match. In SQL Mode you need to get an exact name match every time you use the = sign.

Before trying to do that it might be a good idea to see the exact trainer names so that you can create exact matches.

Run any non name based UDM through the Data Window broken out BY TRAINER and save the results of the query to a text file so that you'll have it for future reference.

Hint: The BY TRAINER results will give you an alphabetized list of trainer names spelled out exactly as they appear in the database... making it easy to create exact name matches from there.

-jp

.

JCapper Message Board

JCapper 101 -- Trainer Name Match in SQL Mode

JCapper 101
-- Trainer Name Match in SQL Mode