Link to home
Start Free TrialLog in
Avatar of DexterJones
DexterJones

asked on

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

Hi,

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

Thanks

Server: Msg 403, Level 16, State 1, Line 9
Invalid operator for data type. Operator equals modulo, type equals varchar.
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DexterJones
DexterJones

ASKER

it was '%' should have been ''%'' for building sql string.