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 = <<<ONSORTCOL
    function (index, columnIndex, sortOrder) {

        if(index=='Prioridad'){
            $("#grid").jqGrid('setGridParam',{
                sortname: "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 "+sortOrder});
            // trigger the grid
            $("#grid").trigger('reloadGrid');
            // return stop to prevent other things
            return 'stop'
        }
    }
ONSORTCOL;
$grid->setGridEvent('onSortCol',$colo);

But JQGrid automatically removes the " ' " character, and does the same with the " ( " and ") " characters if I replace the chars for CHAR(65) for example.

Do you have any ideas?

Thanks in advance.