M
Mahesh
Guest
Scenario: I have a char field(name
riority) 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...
riority) 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...