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

    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
    Location
    One Flump in One Place
    Posts
    14,912
    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
  •