remove problem

• satishthota

  SSC Eights!

  Points: 959

  More actions

  May 1, 2009 at 5:23 am

  #129753

  as per SSChasing Mays

  I had executed following statement

  select ascii(substring(fathername,1,1)) from MyTable

  then how to remove or replace the invisible characters LIKE LINEFEED

  AND NULL

  i found that linefeed(ascii value 10) and null(ascii value is 0)

  gIVE me a better solution

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 1, 2009 at 6:05 am

  #987221

  Well... This the third thread now.

  It becomes annoying!

  If you have further questions answer to your initial thread here