sql order by second letter?

[robvilla]

I'd like to be able to order a select statment's results by the second letter of the field rather than the first. Is this possible?

[bubblenut]

If you're using MySQL then yes

SELECT field FROM table ORDER BY SUBSTRING(field, 2);

If you're not using MySQL then I'm afraid I can't help you.

[robvilla]

You rule! thanks.