From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   On Mon, 18 Oct 2010 09:32:39 +0100, M Joomun wrote:   
      
   >Thanks for your response. The syntax you gave was what I was trying   
   >originally and there's no difference in the results returned; correct   
   >results if 'DateAssayReq' is used as search criteria, no results   
   >returned if labno is used, either on it's own or in conjunction with   
   >'DateAssayReq'.   
   >   
   >Any other ideas?   
      
   Hi M Joomun,   
      
   That might be caused by a mismatch between the data type of the   
   parameter and the data type of the column.   
   Can you post the exact structure of the table, as a CREATE TABLE   
   statement? (You can use the generate function in SSMS to get this, or if   
   you have your table creation scripts in source control, you can use   
   those).   
      
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)