Put Null Values at end of the colunma

Hey , 

I am trying to order a column  i always want, independently it is ASC or DESC , the null/nullidentifier() values at the end of the column . My column is datatype Text. 

Some Idea there, in aggregates or Sql but that works in Outsystems?

Regards

Hi.

You can create a calculated column to turn the value Null/NotNull into binary code.

Order by that one first, and then by a dynamic criteria on the real value

.