with u (a) as ( select 'a' from sysibm.sysDummy1 union all select 'A' from sysibm.sysDummy1 union all select '2' from sysibm.sysDummy1 ) select * from u order by cast(a as varchar(100) ccsid ebcdic )