How Teradata perform comparison on strings using Logical and Conditional Operators.
when 'AAZ' > 'AB' then 'greater'
WHEN 'AAZ' < 'AB' then 'small'
end as result
How greater than and less than work with strings?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.