Hi,

Here's my SQL :-

select id, lastname, firstname, title from per
where trim(both ' ' from firstname) COLLATE UNI_CI like 'Vincent'

This returns :-
ElevateDB Error #700 An error was found in the statement at line 2 and column 37 (Expected end of expression but instead found COLLATE)

If I remove the TRIM or the COLLATE then it works fine, however I really need both.

Is this a bug or am I doing something wrong?

Thanks,

Hedley Muscroft
Pioneer Software

Hedley


Try

select id, lastname, firstname, title from per
where trim(both ' ' from firstname COLLATE UNI_CI) like 'Vincent'

Roy Lambert [Team Elevate]

Excellent - that works thanks.