From: m.a.joomun@qmul.ac.uk   
      
   On 18/10/2010 13:19, Hugo Kornelis wrote:   
   > 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).   
   >   
      
   Hello,   
      
   Thanks for the reply. As requested, below is the structure of the table   
   in question. Not sure if you wanted everything the create statement put   
   out, but shout if you do:   
      
   CREATE TABLE [dbo].[tblAssay](   
   	[AssayID] [int] IDENTITY(1,1) NOT NULL,   
   	[ADtdate] [datetime] NULL,   
   	[ADtTime] [datetime] NULL,   
   	[LabNo] [nvarchar](6) NULL,   
   	[AssayTy] [smallint] NULL,   
   	[ReasonRepeat] [tinyint] NULL,   
   	[DateAssRequested] [datetime] NULL,   
   	[TimeAssRequested] [datetime] NULL,   
   	[PersonReq] [smallint] NULL,   
   	[RepeatedYN] [smallint] NULL,   
   	[DateRepeated] [datetime] NULL,   
   	[DtRepeatDy] [nvarchar](9) NULL,   
   	[PersonRepeat] [smallint] NULL,   
   	[ReasonNotRepeated] [smallint] NULL,   
   	[LIMSUpdateYN] [smallint] NULL,   
   	[DateAssayReq] [date] NULL,   
     CONSTRAINT [aaaaatblAssay_PK] PRIMARY KEY NONCLUSTERED   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)