AnsweredAssumed Answered

SQL sorting on number and date fields

Question asked by deathrobot on Jun 4, 2014
Latest reply on Jun 5, 2014 by deathrobot

Title

SQL sorting on number and date fields

Post

     This works for text fields:

     ExecuteSQL (
     "SELECT
     id
      
     FROM
     Table
      
     ORDER BY LOWER ( Field ) DESC
     ";
      
     ""; ""; "" )
      
     but not for number and date fields. Is there some SQL magic that can account for those types of fields, or do I need to create a calculation field that stores these values as text?
      
     Thanks!
     Michael

Outcomes