Remove junk in description coloumn

  • Hi

    I have table color_test with column remarks nvarchar(50)

    insert into color_test values ('Nav11y cashmere Pablo fishermanóÔéÔäós 13sweater')

    I want to remove the junk characters (óÔéÔäó) in this record.

    Please help. My table has 20,000 rows which contains many rows having junk characters.

  • whether it is a standard junk characters in all the rows or not.

    if you post some more rows , then it would be helpful.

    karthik

  • Some more characters like ths

    óÔé¼-Ø

    with a subtly draping at d+â-®colletage.

    Black linen +óÔé¼-£Gabine+óÔé¼Ôäó peep toe platforms

    Black leather +óÔé¼-£Sexsling+óÔé¼Ôäó

    In keeping with the bootÔÇÖs work origins

    hope usefule

  • http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67997

    Visit the above URL.

    karthik

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

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