I have a column that contains priority levels for jobs - high, meduim, and
low i want to be able to sort these by priority do it goes

HIGH
MEDIUM
LOW

However when i try to sort it puts it in alphabetic order i.e HIGH,LOW,MEDIUM

how can i get around this??

cheers