String data, right truncation (#0) error!

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right 8
Right Truncation warning 10
Unusual reason for Memo truncation 2
Scaling results in data truncation 2
[Microsoft][ODBC SQL Server Driver]String data, right truncation 0
Memo Field data truncated in query 3
SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
Intermittent string truncation error 2

Top