M
Mahesh
Guest
Scenario: I have a char field(nameriority) in my table where values are stored as 1,2,3 and blank("").
for each mytable no-lock by priority:
This query sorts in this order: blank,1,2,3.
for each mytable no-lock by priority desc:
And,this query sorts records like this: 3,2,1 and blank.
But i need to sort the records like this: 1,2,3 and then blank. In ascending order but skipping the blank and starting from 1. Is there any way to sort this out in Progress?
Continue reading...
for each mytable no-lock by priority:
This query sorts in this order: blank,1,2,3.
for each mytable no-lock by priority desc:
And,this query sorts records like this: 3,2,1 and blank.
But i need to sort the records like this: 1,2,3 and then blank. In ascending order but skipping the blank and starting from 1. Is there any way to sort this out in Progress?
Continue reading...