Hi,

At July 3, 2003, 15:33, Ivan Prenosil wrote:

>> SELECT ...
>> FROM ...
>> WHERE FIELDNAME STARTING 'Something' COLLATE NO_NO
>> ORDER BY FIELDNAME
>>
>> works OK, whereas

> Works OK? Are you saying that you see any difference between
> WHERE FIELDNAME STARTING 'Something' COLLATE NO_NO
> and
> WHERE FIELDNAME STARTING 'Something'
> (especially if Something contains national characters) ??

Svein is mentioning that if you replace 'Something' with a parameter
and use a COLLATE as in his example:
WHERE FIELDNAME STARTING :Parameter COLLATE NO_NO
That an error occurs when preparing the statement.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)