[sqlite] alltrim

[Jaafar Aghajanian]

Is there a function for trimming the end blanks.  For example, if I do:

select distinct phn where sur = 'DOUGLAS';

I get no rows selected. But if I do:

select distinct phn where sur = 'DOUGLAS           ';

I get the desired result.
Is there a way to trim the data?
thanks
jaafar
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]