AUTOLOCATE
4 months ago
![]() |
select first 1 col1 from tab1 where col1 = "A" or col1 = "AB" or col1 = "ABC" or col1 = "ABCD" or col1 = "ABCDE" or col1 = "ABCDEF" or col1 = "ABCDEFG" or col1 = "ABCDEFGH" or col1 = "ABCDEFGHI" order by length(col1) desc
Send your suggestions, questions, complaints, general greetings and cash donations to andrew@informix-dba.com