remove spaces from string

[#1]

hi all,

i have a string: 'a b c'

which function do i use to remove the spaces in this string, to retrieve 'abc' ?

thanks a lot!

[CELAMBARASAN · Accepted solution]

Hi,

     Try using replace

     Replace('a b  c',' ','')

Celambarasan

[Sokkorn]

Hi,

I think Celambarasan is right. Just want to add more on this TRIM(REPLACE(Field,' ',''))

Regards,

Sokkorn

[sivarajs]

Hi,

i have another option

purgechar('a b c',chr(32))

Regards,

Sivaraj S