Consider the table T1 in Example: Implicit Type Conversion During Assignment.
In the following statement, Teradata Database implicitly converts both operands of the comparison operation to FLOAT values before performing the comparison:
SELECT Fname, Fid FROM T1 WHERE T1.Yrs < 55;