String data, right truncation (#0) error!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I am trying to run a query and getting "[Microsoft][ODBC SQL
Server]String data, right truncation (#0)" error message.
I was able to locate the criteria that is causing the problem. And it's a
greater than 0 condition I use under a field which is supposedly a number
column in a view. I tried a couple of different format function but no luck.
Can any one please tell me how to overcome this error message.
Thanks in advance
 
Back
Top