I am using feed module to import form excel file, one of my field is  a incremental number 1,2,3,4,5 ,..... ' , I get it as 'GUID' in feed importer.
I want sort the result in views, I see the views get GUID as a string and sort it by string.anybody have idea how can I sort them as number ?


I test this but it return me sql error,

    function mymodule_views_query_alter(&$view, &$query) {
    if ($view->name == 'my_views') {
    $query->orderby[0]['field']='CAST('.$query->orderby[0]["field"].' AS INTEGER)';    
    }

or I try 

    $query->fields['feeds_item_guid']['field']='CAST('.$query->fields['feeds_item_guid']['field'].' AS INTEGER)';


**error of second try**: `SQLSTATE[42S22]: Column not found: 1054 Unknown column 'feeds_item.CASTguidASINTEGER' in 'field list'`