Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bertrand82
Starting Member
7 Posts |
 Posted - 2012-10-15 : 08:54:28
|
| Hi,I have a query with the following fields. (SQL view from Mircosoft Access)SELECT tblGIUSA.Company, tblGIUSA.FirstName, tblGIUSA.Surname, tblGIUSA.EducationalLevelFROM tblGIUSA;What will the SQL code be if I would like to change e.g:- The values in Field Company to 25 = "North America", 50 = "South America" - The text in field EducationLevel to "Bachelor degree" = "low education" and "Master degree" = "High education" Thanks for all help.Br Bertrand |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-10-15 : 09:23:32
|
Do you want T-SQL or some Stuff for MS Access?
Too old to Rock'n'Roll too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-15 : 10:34:50
|
| do you've a mapping table containing the values to be replaced against lookup values?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Switch/Select Case