Json with Sql Right or Left

I cannot get Right or Left to work. Substring works.

Hey @nroeder! Would you mind posting a screenshot or the code for the query you're using? It would also help if you could show us what you're passing in any {{}} either by hovering over them and sending a screenshot of that or copying the respective values from the left panel!