Skip to content

Monthly Archives: March 2015

Access 2007 SQL the default value for switch

20-Mar-15

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 …