You just stuck "Ramsay Hunt Syndrome" into the field name to see if I was going to read your post. <g>

>Using Sergey's idea of derived tables it would be something like:
>

>lnLength = 30
>lcString = PADR('Other', m.lnLength) + ;
>           PADR('Primary,m.lnLength) + ;
>           PADR(Secondary,m.lnLength) + ;
>           PADR(Teriary, m.lnLength) + ;
>           PADR('Workmans Compensation',m.lnLength) + ;
>           PADR('Auto',  m.lnLength)
>
>select * from ;
>(select substr(THIS.Strip(TRANSFORM(SUBSTR(m.lcString, at(Covr.CvPS, m.lcString), m.lnLength))) ;
>	AS IN1_22_00_Coord_of_Benefit_PriorityRamsay Hunt Syndrome, ;
>at(Covr.CvPS,"PSTAW") as selOrder from ... order by selOrder)

>
>This is untested - written from the head, may need some tweaking.
>
>BTW, are you sure you want to have custom method in the SQL? May be there is a simple expression for the first field?
>
>What do we want to do in case of Other with the order?