problem with DbiGetRecordForKey and Partial matches

Is there a problem with partial matches when the string contains a space at
the end??

I am trying to do a partial match on a text field using DbiGetRecordForKey
with a string such as "D " (space after the D) .. there is a Key with the
value "D Archy" but it returns DBIERR_RECNOTFOUND. If the string does not
end in a space the match is fine.

Any ideas?? I am using the latest BDE on a paradox table.  The search is
using a secondary index based on two string fields.

Thanks,
Paul.