operand data type varchar is invalid for divide operator
when does this error happens ? need example.. pls
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
HanookPosted Nov 21, 2013, 1:45 AM
Even though you have numeric data in the column check the data types of the columns and then convert each column that is part of division operation to numeric ( int )
Rohatash KumarPosted Nov 19, 2013, 4:03 AM
You can convert like this way:
This will work if your varchar column actually holds numeric value. Otherwise, you can try casting it using
castfunction like: