Invalid operator for data type. Operator equals modulo, type equals varchar.


Please kindly assist how can we resolve the error and what does this means?


Server: Msg 403, Level 16, State 1, Line 9
Invalid operator for data type. Operator equals modulo, type equals varchar.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have somewhere a module operator with at least on of the arguments being of data type varchar.
without the offending query code we cannot help more
Aneesh RetnakaranDatabase AdministratorCommented:
you need to convert your field to 'int' before the % opr


cast (urField as int) % somvalue

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DexterJonesAuthor Commented:
it was '%' should have been ''%'' for building sql string.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.