switch or chose function?

[mo]

I have a bunch of hospital codes that look like this:

L, S, U, R, G etc.

In a query I need to transform these into

Llan, Sing, UHW, etc etc.

Which function should I use to do this and how does it work?

Thanks for any help.

Mo

 

[Bas Cost Budde]

I have a bunch of hospital codes that look like this:

L, S, U, R, G etc.

In a query I need to transform these into

Llan, Sing, UHW, etc etc.

Which function should I use to do this and how does it work?

Thanks for any help.

Mo

Store the values in a table and link that. Your new table would look like

abbr expandedName
L Llan
S Sing
U UHW
R etc
G etc.
;-)

In the query you can draw a line between the tables, pointing out the
fields that should match. Put the expandedName in the field list to show.