Hello,

I have a grid where there is a row called 'Priority' when the user presses on the header of that row, JQGrid sorts the grid but it orders it placing the value 'A' before 'A1' that is the logical thing. The problem is that I want to force it to be opposite so I developed this query that it works in my SQL Server:

“CASE Prioridad

WHEN 'A1' THEN 1

WHEN 'A' THEN 2

WHEN 'B' THEN 3

WHEN 'C' THEN 4

WHEN 'E' THEN 5

ELSE Prioridad + 6 END, Prioridad”

I applied it in my code (I use JQgrid for PHP) as follows:

$colo = <<