Order by Numeric value of a Varchar column Need a better solution

  • Yes I am only the concerned about sorting for numeric values in the column but if it contains alpha Numeric then sorting can take any course of action.

    ~D

  • Thank you all for your valuable suggestions. I would evaluate each of this and I think the one padding or the order by lenghth and the data will eventually be my solution. As I said I still don't have complete picture of data range, I cannot pin down the requirements at this time. But these solutions may just do the work.

    Once again thanks for your time and suggestions.

    !D

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply