Comparing Long Text datatypes

[MarkEmerson]

Hi all,

I'm having a problem comparing two lots of text that is stored in a sql server db as long text datatypes.

All I want to do is a simple compare statement like:

---------------------------
If var1 <> var2 then
booTest = True
Else
booTest = False
End If
---------------------------

This works fine for varchar or char datatypes but it doesnt for long text. Any suggestions?

 

[MarkEmerson]

Has anybody got any workarounds?

 

[MarkEmerson]

Sussed where I was getting the error - It wasnt the datatypes at all.

I am using a text editor to update text and then compare it against the old text. However when the text is displayed in the text editor it converts double spaces to single spaces. I've added a bit of code to eradicate this and al is right in the world again!