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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Switch/Select Case

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.EducationalLevel
FROM 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.
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -