September 17th, 2003, 08:11 AM
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...
September 18th, 2003, 01:25 AM
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?
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
September 18th, 2003, 03:20 AM
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.