Recent content by sdahlstrom

Is there a way to retrieve the data in a character field that extends beyond the defined length of the field without altering the database? example: field1 format is x(5), data is x(7) field1 value = "JOHNSON" SQL Stmt = "SELECT field1 FROM table1" result = "JOHNS"