Issue with a url query in SQL Calc Field

Question

Does anyone else have an issue in AGOL calculating a filed to update a url link with a "?" in it? Every time I tried paste a url with a query (ex: https://..../DistrictBallotView.aspx?DistrictKey=31.......) it changes the "?" to a ":" (ex: https://..../DistrictBallotView.aspx:DistrictKey=31.......) To be clear, I'd paste the url and it looks fine. I hit calculate and the result has the colon instead of the question mark. This ONLY seems to happen in the SQL version of editing. I had to change settings on the feature class to be able to make the edit in Arcade and then change the setting back.

RobertoRossi · Answer

I have the same Issue.

Both the solutions proposed by @LanceCole do not work:

* with double question mark "??" you obtain "@"
* with the question mark in brackets "[?]" you obtain "[:]"

here a workaround if the value is needed for a popup: https://community.esri.com/t5/arcgis-online-questions/calculated-url-converts-question-mark-to-colon/td-p/1288161

Roberto

LanceCole · Answer

Ryan‌,

A "?" is a placeholder in a SQL statement depending where it is located in the statement.  If your URL is contained in quotes as part of the WHERE clause is this should be ok other wise the SQL will replace the ? with a value.  Depending upon the driver and SQL version, using a double question mark "??" or wrapping the question mark in brackets "[?]" in the URL may escape the issue.  Can you provide a copy of the full SQL statement?