return an smallint like a roman number

I want that a select return one smallint column into roman numbers.

The colums contains values like: 1, 2, 3, 4...
I want the select return this values in roman numbers: I, II, III, IV...

Thanks,
Eva Janakieff

This is probably easier to do this in the front end with a programming language (say perl or VB) rather than in a select statement. Can you use a programming language to format the data or does it have to be in a SELECT?

I know how to do this with VB, but I want to do it directly in the Select, because I use the results in diferents VB6's Data Reports and in diferents Crystal Reports.

I think that in Data Reports it's no possible create a formula to make the transformation.