remove or replace

• satishthota

  SSC Eights!

  Points: 959

  More actions

  May 1, 2009 at 5:18 am

  #130521

  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

  My excel data contains following information (myexcel.xls)

  OwnerName FatherName RationNO

  Thirupathi Vittal Wap 182501100164

  Thirupathi Vittal NULL

  RAM VIJAY Wap 182501100167

  RAM VIJAY NULL

  Im importing excel data to sql server database (Sample Table)

  after importing excel data into sql server im getting spaces before fathername and after fathername

  when im using ltrim or rtrim it is not working
  Then How to remove the spaces

  Can u give me a better solution to solve my problem?

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 1, 2009 at 5:20 am

  #987213

  Duplicate post. Please answers here:

  http://www.sqlservercentral.com/Forums/Topic708326-338-1.aspx

• Noffer

  Ten Centuries

  Points: 1090

  More actions

  May 1, 2009 at 2:34 pm

  #987587

  Like Flo said, stick to the existing thread, or get a book.

  I posted a reply there