Recordset Help

[LiquidD33]

Hey all,
I am wondering if someone could help me create an SQL query for a recordset I
am building.
I have a database with many tables. In one table, records are inserted by a
program, and the other tables are for references. What I am trying to do is
take a column (ex. utilites) that has this string it it- (235,365,5, 11, etc)
and convert it to a Feature (ex. Water, Electricity) The Feature Table has 2
columns, the numbers, and the value (or feature).

How can I write the SQL to take the 235,365,5,11 and convert it to my Feature
value?

Thanks ahead if someone can answer this.

[brownd1]

Create a look up table (LOOK) within the database with 2 columns -- one will
be: utlSTR and the other will be: featureSTR.

Column utlSTR = 235
Column featureSTR = Water


--------------------------------------------------------------------------------
-------------
So, SELECT * FROM LOOK, SOMEOTHERTABLE WHERE LOOK.utlSTR = SOMETABLE.utlSTR
and featureSTR = 'Water'

--------------------------------------------------------------------------------
-------------

Does that help?