replace number with string name

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • varann
    New Member
    • Nov 2012
    • 1

    replace number with string name

    Hello,

    how can I replace numbers from -1 to 15 with string in MSSQL? For e.g.:
    -1 = TEST1
    1 = TEST2
    2 = TEST3
    ...
    12 = TEST123
    13 = TEST1234

    Thank you!
    Fredy
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32653

    #2
    You give no explanation and your example makes it very unclear what is behind your thinking.

    Nevertheless, a table of matching values (that match your logic whatever that may be) would work for you.

    Comment

    Working...