RE: First SQL UDF

This worked! Never assume default sizes!

Create function CharOrder
(numb DEC(8,0))
Returns char(7)
language SQL
returns null on null input
begin
declare alpha char(7);
set alpha =
Substr(Space(7), 1, 7 - Length(Trim(Char(numb)))) Concat
trim(char(numb));
Return alpha;
End

select cj.*, charorder(aiorder),
Substr(Space(7), 1, 7 - Length(Trim(Char(aiorder)))) Concat
trim(Char(aiorder))
from cj

....+....1....+....2....+....3....+....4.
AIORDER CHARORDER String Expression
27 27 27
******** End of data ********


Rob Berendt