Hi, I'm new to sql so apologies if my question is not explained 100% correctly. I'm using Oracle SQL developer. I have a table that is called 'DAYS' Within that table are seven fields A,B,C,D,E,F,G each relating to the days of the week (A relates to monday, B relates to tuesday etc) and multiple rows. I need to do a where from whichever field is relevant for the day of the week that the person executing my SQL query inputs. I know about the :variablename bit to get the input and have used it in other sql queries, but not how to decide the field to use for my 'where' based on that input. The actual SQL is a bit more convoluted than this obviously, but in simple terms what I need is. e.g User inputs 'monday' so my SQL should execute: select * from DAYS where A is not null User inputs 'tuesday' so my SQL should be: select * from DAYS where B is not null etc, etc. I know I could simply ask them to run a different SQL query on each day of the week, but that seems a bit rubbish. How can I achieve this with a single SQL query ? Many thanks in advance for any answers provided.