This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
i do query using below SQL syntax and i got the result
but if i uncomment the 'where' syntax i got error
I very strange why the error say about arithmetic since the filter only using string and not use any calculation.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
The problem should be with the data type. Can you provide some sample data so we can test the code?
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
I very strange why the error say about arithmetic since the filter only using string and not use any calculation.
Without knowing the table design = data types per column we even can't guess it.
Check the data type of every used column.
Is NetFlowFlows_ViewByConversation a table or a view? And if is is a view, does it have its own WHERE clause and filtering?
When you query a view, the view is only a macro that is expanded into the query, and the optimizer works with the expanded query. When you added the query filter, you may have gotten entirely different execution plan altogether, so that an expression that logically is filtered out, is now computed before the filter and therefore you get this error.