Add built-in cast function for SQL queries
Need built-in function for casting string datatypes to INT, NUMBER, DOUBLE, etc. in SQL queries as our data loader is converting the number to string during document creation. We have a requirement to filter on numeric values in our application.
This feature is now generally available. For more information on the latest features for our SQL language syntax please visit, https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-query-reference
That's great news. The link provided does not reference a 'cast' or 'convert' function. Please update with a direct link to the docs that reference to functionality in question? Thanks.
Nick Smith commented
Please add group by
Trutz-Sebastian Stephani commented
Provide CAST/CONVERT syntax for SQL queries to allow for numeric range queries and also for things like on the fly creation of data points for distance queries.