468,243 Members | 2,024 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,243 developers. It's quick & easy.

replace number with string name


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!
Nov 29 '12 #1
1 1915
32,053 Expert Mod 16PB
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.
Nov 29 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Joel Finkel | last post: by
11 posts views Thread by jarod1701 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.