I like to convert CR and LF which is coming in a particular column to Empty string.
I tried the following but it was not converted.
Code: Select all
Convert('chr(10)chr(13)','',COLNAME)
Cheers!!!
Moderators: chulett, rschirm, roy
Code: Select all
Convert('chr(10)chr(13)','',COLNAME)
You quoted the char functions you were attempting to use so they just turned into a 14 character string.mac4rfree85 wrote:I tried the following but it was not converted.
Code: Select all
Convert(Char(10) : Char(13), "", InLink.COLNAME)
Code: Select all
Convert(svCRLF, "", InLink.COLNAME)