I just realised this may not apply to your IR.
I recently solved an ordering issue in 4.0 by adding hidden html in the column prior to the value.
This content came from my sql using an analytical function, yours might be
,rank() over (order by to_number(regexp_replace(your_col,'[[:alpha:]]','')), your_col )
Ok. I ckecked your statement on an other interactive report, where I have the same issue.
Here it works.
But I Think there are to many negative parts for me, if I use this.
So, I only can order my "Main" column with the help of the the column from your query.
Maybe also User want to sum values. It will also not possible.
I presented the requirements not really exactly,hehe^^
Thank you very much for your help
without regexp option:
, case when instr('#1#2#3#4#5#6#7#8#9#0#',substr(vc,1,1)) = 0 then 1 else 0 end sort_column
select '10' vc from dual union all
select '2' from dual union all
select '23' from dual union all
select '3' from dual union all
select 'no' from dual union all
select 'yes' from dual union all
select 'yas' from dual
order by 2,lpad(vc,'9',0) --First sort on numbers, then on characters