Thank you both for your help, I have managed to do it by using a dynamic query as you said.