I am having an issue with pulling a basketball player's information if their jersey number is 0 or 00. I've gone through the process of setting up the datalinq key with %Jersey% and have inserted the following into the Datalinq properties Table line (this information matches my column names):
SELECT [First Name] FROM [Roster] WHERE [Jersey #] = %Jersey%
Now, every other player number I insert into the Datalinq Key Value field generates the correct information. Is there a solution for players with the #0 or #00? Thanks.