Compare two NTEXT columns

  • How can I check the value of two NTEXT columns against one another?  I know I can check the length using DATALENGTH, but that does not deal with transposed letters, etc. in the two fields.  Any suggestions?

    Thanks,

    Alex

  • There are third-party applications that can help - SQL Data Compare 3.

    There is a t-sql reserved word - readtext - that might help.

    Quand on parle du loup, on en voit la queue

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

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