format for SWITCH in SQL

[krisleech]

Could someone please tell me the format for the SWITCH clause in an SQL statement.
And also where the SWITCH command goes within a SQL statement.

I cant find it on the net or in Access help!

What i am trying to do is take a number and turn it into a string without changing the orignal data just for display purposes.

Many thanks Kris.

 

[Mile-O]

If you open a module, type SWITCH and press F1 the Access help for Switch appears.

 

[krisleech]

SWITCH statement in SQL

Many thanks for that.

How would i incorperate SWITCH into an SQL statement?

I thought SWITCH was a native SQL clause, but it seems it is a Visual Basic function.

Kris.

 

[Mile-O]

SELECT ArmyID, Rank, Switch([Rank] = "Private", "Grunt") As NewRank FROM tblArmyPeople;