I have in my MS SQL dB a field called KatNr. Im sorting by KatNr Desc. I get:<BR>189<BR>19<BR>191<BR>192A<BR>I found out thats how text is sorted (because of the A). How can I sort this like numbers?<BR><BR>Hedge
One thing I had to do in the past is create another column, a sorting column, and if sort like that, otherwise I don't know another way to sort numbers in a text field.