• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Truncated Data From Sql View

I'm trying to query from a SQL view and am getting strange results in my application. If read the length of a field - DISPLAY LENGTH(contactName) I'll get a result that makes sense - like 24 characters. However, when I attempt to display the field itself, I get only the first character.

A Display statement yields an error - "FILL-IN contactName will not fit in frame in program". If I display a substring, export to a file, view the field as an alert-box, or any other way to see the data, all I see is the first character.

Does anyone have any suggestions on how I can troubleshoot and resolve this?

Much appreciated!