Retrieving Data Longer than Defined Field Length?

[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"

 

[MurrayH]

You need to change the sql-width part of the schema but the good news is this won't effect your CRC