#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    8
    Rep Power
    0

    Question 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
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,638
    Rep Power
    4247
    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
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    8
    Rep Power
    0
    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.

IMN logo majestic logo threadwatch logo seochat tools logo