Table Listing Order - How do you order blank items last?

I have a database of items . One of the fields is a Rating and the table listing is set to order on that Rating Field.
How do I sort it so those that have no rating (the field is empty) to display below those that have a rating (the field has content).

you can use custom ordering => choose rating field and sorting type by number for exemple

I have it on custom sort by Rating (by the way Rating is a custom field I created.)

The ratings are on a numerical scale of 1-20. I have it sort by ascending order so a Rating of 1 which is the highest rating is at the top, but instead all of the items with no rating or blank rating show first.
Is there a way to make the top rated appear first but the blank ones at the bottom?

or should I just make the non rated people a higher number than 20??

number is 0-XXX always
nothing is 0 did you try second ordering ?

Hello

no-values are saved for all built-in fields by not addin a DB row (aka value is NULL)
so unless you have code a new FLEXIcontent field TYPE, and you have made something different in "onBeforeSaveField"

using (with a performance impact ...):
ORDER BY ISNULL(value) ASC, value ASC

instead of:
ORDER BY value ASC

will work ... will add it

Hello

i checked and placing NULLs last is already implemented

- what type of field type are ordering ? e.g. is it a "text" (text, number, etc) field
- what is the ordering configuration ?
- are you ordering in category view or in universal content module , both ?