update table from a value

[carranz]

I have a table that has 6 fields.

One field named DAYS
the others are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY

Within DAYS field there is 6 spaces. Value in the field would be M on 2nd space. another value would W on the 4th space and a F on the 6th space.

example
M
W
F

I want to read the value from DAYS field if there is a M in the DAYS field put an X in the MONDAY field. IF there is a W in the DAYS field put an X in the WEDNESDAY field sam for FRIDAY.

What would be the best way to do this
any help would be appriciated

 

[lespaul]

Can you tell us what you are using this table for? I can't believe that this is the best way to store the information...

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi