1. I want to select 5 fields from a db2 table of which 2 are varchar field of length 50 bytes.
2. Requirement is to view only the first 15 char of the 2 varchar field and also to sort those 2 varchar fields in ascending order.
3. I cannot use SUBSTR(Column_Name,1,15) in SELECT stament because ORDER BY clause is having the Column_Name.