Ordering string represntations of numbers

From: McBrayer, Roy (Roy.McBraye..ail.va.gov)
Date: Mon Jul 26 2004 - 15:21:18 EDT

  • Next message: David Norwood: "How does noMatchExp() work?"

    Is there a way to order a query of a varchar field that actually represents
    numbers in a similar fashion to using the toNumber function in SQL?

    Right now, as expected, 16 is ordered before 2 since I am dealing with
    Varchars.

    Thanks,
    Roy

    This archive was generated by hypermail 2.0.0 : Mon Jul 26 2004 - 15:21:20 EDT