blanks in like comparison

Hi everyone.
I've got a problem with some blanks in a like comparison. I'd like to know, if there's a possibility to cut trailing blanks, so they don't matter in the statement as in the Databasefield.

e.g.
Select * from dummy where d1 like 'me %' finds a field 'me'

Is this possible?

Thanks Frank Received on Thu Sep 23 1999 - 10:45:26 CDT