From: "Daniel Rail" <daniel@...>

> 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.

I understand Svein's question. I just wanted to point out
that specifying collation with STARTING has no effect anyway
(so it is pointless to prepare such command).

Ivan