Text Data Type
All ASCII characters except the null character ("\0") are allowed within text strings; null characters are converted to blanks.
Blanks are not ignored when you compare text strings. Unlike varchar, if the strings are unequal in length, blanks are not added to the shorter string. For example, assume that you are comparing the text strings
"abcd"
and
"abcd "
The string "abcd " is greater than the string "abcd" because it is longer.
Text is supported for backward compatibility, but varchar is the preferred varying length character type.