Thursday, December 20, 2012

TRIMing single quote from the String

RTRIM(LTRIM(Input_String,CHR(39)),CHR(39))
Note: Here CHR(39) will return the ASCII character which is ' (single quote)

No comments:

Post a Comment