• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 804
  • Last Modified:

How do I compare nText fields

When I update a certain table I add records to an audit table that show any changes made to the fields. I have an nText field that I need to compare the original value against the new parameter that will be used to update the field. How can I do this?
0
Bryan_123
Asked:
Bryan_123
  • 3
  • 2
2 Solutions
 
muzzy2003Commented:
You can only compare ntext values using LIKE not =. Is this enough to get you unstuck?
0
 
LowfatspreadCommented:
is it truely a TEXT column or is the size limited to something reasonable like 64K?

if its small then

you can convert the chunks to varchar(8000) pieces and compare those,
initially do a Datalength(Old) = Datalength(New) test,.,,
0
 
Bryan_123Author Commented:
Will that tell me if the value has changed?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Bryan_123Author Commented:
It's an nText column that I expect will be huge.
0
 
LowfatspreadCommented:


then use the BINARY_CHECKSUM or CHECKSUM function...

so

Where  Datalength(OLD) <> DataLength(NEW)
 or Binary_Checksum(OLD) <> Binary_Checksum(NEW)

the "checksum" functions compute a hash value based on the data within the column
so its extremely unlikely that a change in the column data would generate the same hash...

see BOL , Functions for more details

HTH
0
 
Bryan_123Author Commented:
Thank you very much. I used a combination of both of your answers.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now