No, direct ordering or grouping on memo field is not allowed. You can first convert memo to a string (limited to 254 characters) and then do sorting/grouping on it.

SELECT ... FROM (  
   SELECT PADR(mymemo,254) AS mystr, ....) dt1 
  ORDER BY mystr

>Could I be able to put a memo field on SQL Select into order by or group by. I tried using mline() function but it did'nt work. Is there anyway I could do it.