I'm trying to create a database view using the CreateDatabaseView tool. The SQL statement includes a forward slash as a division symbol and it appears to be causing an error. For simplicity let's say "SELECT 5/2 as x". The SQL statement is valid and when I change from division to any other math operator it works. I've tried every trick I can think of to get it accepted but no luck. Any idea?
The error from ArcGIS Pro is: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds
From Python it is a little more explicit: [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '2'.]
It appears that the tool is stripping out the division symbol.
ArcGIS Pro 2.8.3
SQL Server DB
