Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Unanswered: SQL Query to convert Text data to Varchar datatype

    Can anyone please help me in converting a varchar data into string/text and viceversa.I update column as varchar datatype with string data having special characters.but later when I try to retrieve data special charcates are appended with the some other character.

    For illustration :I have a string data 'first&last' after updating the varchar column when i retrieve It returns as 'first&last'

    So please provide me info on elminating the extra charcacters appended to special character

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    SQL Server hasn't done that. What are you using to view and change the data?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts