Trying to write this SQL statement

[patrickABAWF]

[ FlexSim 21.2.4 ]

I'm trying to write this SQL Statement but there is a problem with the line before last:

Table result = Table.query("SELECT * FROM FRList1 \
WHERE [ChoiceC2] > 0 \
AND [Content] > 0 \
AND [Content] < 10 \
AND 'token.item.Purity' = [Purity] \
ORDER BY ChoiceC2 ASC");

token.item.Purity is a string label and [Purity] is a string column in my table.

But I never get a match because of that line although there are matches that I can see.

Is my synthax correct?

Thanks a lot,

[Matthew_Gillespie]

@Patrick Cloutier It doesn't know what token is.

[patrickABAWF]

How do I write it then?

[patrickABAWF]

I've spent hours in the manual and on w3schools and I can't figure it out...

[patrickABAWF · Accepted solution]

I found it !!!

Table result = Table.query("SELECT * FROM FRList1 \
WHERE [ChoiceC2] > 0 \
AND [Content] > 0 \
AND [Content] < 10 \
AND [Purity] = $1 \
ORDER BY ChoiceC2 ASC", token.item.Purity);