how to convert text to number in a SOQL query?

Question

Can somebody please help me figure out what is wrong with this query?

It failed with error code: query.soql.type-mismatch

the "speed" column of the table is declared as text. I am having trouble in converting speed to a real (decimal) number for the comparison. Thanks

score 1 · Answer 1 · answered Jan 08 '18 at 21:44

1

Try casting the column with ::number, like this:

GET https://data.cityofnewyork.us/resource/i4gi-tjb9.json?$where=speed::number > 31.69

answered Jan 08 '18 at 21:44

chrismetcalf

score 0 · Answer 2 · answered Oct 09 '20 at 21:10

0

Put the number in parenthesis, like this:

or if you need it url encoded, use this:

answered Oct 09 '20 at 21:10

Ben Shoval

2 Answers2