Kbase P48888: SQL server character field contains trailing spaces causes f
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/17/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Progress 9.1B
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
A find statement fails when trying to locate exact match on character fields
4GL TRIM function causes performance problems with large tables
CAUSE:
Records retrieved from the MS SQL Server database have fields containing trailing spaces
FIX:
Write stored procedure and use RTRIM and LTRIM function to trim spaces from SQL server side.