remove or replace

  • 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?

  • Duplicate post. Please answers here:

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

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

    I posted a reply there

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply