Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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