I have a requirement to match numeric data of a column for a match with data in column with multiple numeric value seperated by hypen.
Sys_calendar.day_of_week (Numeric field with values range from 1-7 denoting Sunday - Saturday)
Mytable.Mycolumn (String field with values 'ALL' or 0-7 seperated by hyphen. Numbers denote Sunday-Saturday. All means it is for all days. specific numbers mean for those matching days)
So mycolumn can be in different combinations.
For numbers mismatch i can subtract 1 from sys_calendar.day_of_week but I dont want to use case statement to achieve rest of the logic. Any better solution please?
I realize that my logic does not work :-(
I will not know what my day_of_week is and thus cannot put case statement like that... any suggestions appreciated