Sounds like you need a table for this:

The order is B,BB, A, AA, AAA, & AAAA.... something like

CREATE TABLE LoookupTable(

stringValue CHAR(4) PRIMARY KEY,

Seq TINYINT NOT NULL UNIQUE

);

then you'd join to that and order by Seq.