To rephrase my question: What's the logic for the order of the numbers which are not x0x, meaning where the second digit is NOT 0? In your case these numbers are 270, 280, 290, 320, 450 and 545?
NB! Please enable Auto quote, so that I can see the earlier messages when I reply. Hover the mouse over Message view setup in the upper right corner of the message area, and the option will appear.
>Thanks for your reply sir Tore.
>
>I need to generate a balance sheet report where 201 is the account code for office equipments and 301 is the code for accumulated depreciation for office equipments. My user wants 301 to come after 201, and 304 (accumulated depreciation for motor vehicles) to come after 204 (motor vehicles) and so on.
>
>I am actually looking for a SELECT-SQL statement to do this but can't figure out how.
>
>Thanks!