Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
Access 2007 SQL the default value for switch March 20th, 2015

I am using switch statement in access 2007, i want to know how I can specify default value.
select
switch
(
MyCol = 1, ‘Value is One’,
MyCol = 2, ‘Value is Two’
) from MyTable
-

SELECT
Switch(MyTable.[MyCol]=’1′,’Terrestrial’,
MyTable.[MyCol]=’2′,’Value …

Posted in Access || Comments Off on Access 2007 SQL the default value for switch