Kbase P26401: Character fields contain spaces in the records retreived wit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Character fields contain spaces in the records retrieved with the DataServer
Running the code that concatenates record field values displays lot of spaces
CAUSE:
Records retrieved from the MS SQL Server database have fields containing
trailing spaces.
FIX:
Remove the trailing spaces from the character data type fields using
the TRIM function.