Kbase P20994: FIND FIRST with BEGINS doesn't find the record using MS SQL DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
FIND FIRST with BEGINS doesn't find the record using MS SQL DataServer
No results are returned from the query where there are matching records
CAUSE:
One of the two fields used in the query is CHAR data type.
This field causes the problem.
FIX:
Change the CHAR field to be VARCHAR data type.