Eliminating single quotes from the charts ?

[#1]

Hi All,

I have a list box with single quotation at the beginning and the end of the value of the field.

How can I get rid of this single quatation .

Thanks

Mallikarjun

[swarup_malli · Accepted solution]

Hi Malliarjun,

Wt a coincidence u r the 2nd person to post this question today ..

Try this one

     purgechar(Fieldname, chr(39)) as newFieldname.

This should do.

char(39) is the ASCII code for the ' character. You can see the full list of ASCII characters with a decent explanation here: http://www.asciitable.com/

Regards

Swarup