Comparing values that are text data type in SQL

[Lduraisamy]

How to compare fields that are text data type instead of converting them to varchar(8000) like the field can contain data which spans more than 8000 characters say. I dont want to split my field into two also and check. Thanks in advance.