day calculation

[#1]

i have the following table

location      Number      Day

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

Mezyed     MQ2011      Mon

Another Table

Location            Days

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

Mezyed            Mon | Wed

where this table shows what days for each location  would be odd numbers,  so we have to check if the last number in Number is odd to match the day.

This is very important. If there is another way for table 2 to be designed to make it easier then bring it on. but first table not to be changed

THANKS
BILALELABD

[manideep78]

Hi,

I didn't understood what you have said

Please can you explain your problem clearly.??

[#3]

I have medical number as 'BM021234' so i need to check the last character if odd or even, that is 4. how can i do this??