Ah, thanks that worked. I will amend the procedure.

Thanks again.

I orginally noticed the problem when a stored procedure wasn't returning any results so I updated the data type of the parameter being passed to the procedure to nvarchar. This...