String comparison optimizer process

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything

String comparison optimizer process

How Teradata perform comparison on strings using Logical and Conditional Operators.

 

For example

SELECT

case

     when 'AAZ' > 'AB' then 'greater'

     WHEN 'AAZ' < 'AB' then 'small'

     else 'equal'

     end as result

 

How greater than and less than work with strings?