Dear All,


A field of a table (log_user) (VARCHAR(50)) is used to log the authorization level, e.g. TS,MT
means the user can login for TS or MT shops.

However, the real name should be TS = Tesco & MT = Maytower

A Table called the location

Code Name
TS Tesco
MT Maytower

My question, how to select from the character field with the location table,

select name from location where code = (log_user.location) into cursor Tmp