Thank you for your reposnse, however my question is parameter based i.e. i don't actually have/need ( i've simply inputted SELECT 'fred' to avoid any errors).

The UserID as...

Appreciate the advice, however working for the NHS you need for be VERY careful with data security. Confidentiality is king around here and any breach is taken very seriously. So...

Thanks for the feedback, I'll look into OPTION(RECOMPILE).

He may be wrong, but I won't be the one to tell him that 😀

Right I see what you mean. Looks like wires have been crossed somewhere along the line.

Cheers for the advice.

I read everything including the link to 'dynamic search conditions' and then wrote the code. It was when it was ready to deploy that my boss pointed out that isn't...

I noticed that the link posted uses 'sp_executesql'. Is there any other method that uses a process that is more secure? This search function is to be web based and...

Thanks for the quick response. I'll give that article a read now.