Row numbers - ordering - Update issue

[cognosun]

We have a string column( say 'Random') with 4 values in it say...Pen, Paper, Ink, Sketch.

When user drags 'Random' column in a list...he should see values in this order...( Sketch, Ink, Paper,Pen)..which is not related to ascending or descending sort.

So I wrote a case expression by assigning numbers ( 4 numbers --> 4 strings) to above strings and sorted it as expected and issue resolved.

But now the original problem is what if tomorrow if this column ( 'Random')  get's update with additional values like Book, Envelope etc. !!!

User is expecting that all the other values after 4th value may fall randomly anywhere....he's fine with ordering first 4 values which is already in place.

Can anyone suggest.

[tjohnson3050]

In your case expression, do else 5

[cognosun]

Thanks John.

That is indeed the solution :-)