kkiboo Posted July 19, 2010 Share Posted July 19, 2010 Forgive me if this is a newbie question. All the data I am trying to display is numeric, but to display it to the users, I want it to be displayed as something else. Here is an example. My TEAM table, the column TEAM NAME, the first row value is 1. I want the user to see 'Pink Team' instead of 1. But I want all the data on the backend to still be numeric. How do I do this? Aliases? Casting? Help! Quote Link to comment Share on other sites More sharing options...
Maq Posted July 19, 2010 Share Posted July 19, 2010 You need another table to store this sort of team information. Then you can join the tables on the team id and look up whatever information you need. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.