supress leading and tailing space

[iccsi]

I would like supress leading and traling spaces for the string.

Can you please advise which function is available to do this?

Your help is great appreciated,

 

[Dorian]

TRIM(<fieldname>)
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[inungh]

TRIM(<fieldname>)
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".







- Show quoted text -

Thanks millions,