Hi, I am trying to open a table whose name can be variable, but am having trouble getting this to work: SELECT * FROM CONCAT("table","Monday") doesn't work. SELECT * FROM tableMonday works fine of course. Ia there something like this ? : SELECT * FROM EVAL(CONCAT("table","Monday")) I'm trying to do this in SQL only, I realise it would be pretty easy from PHP or something. Thanks, Richard.