Indeed it was! A schoolboy error! Thanks for the prompt reply.

Magic - Thanks very much Chris.

So how do I now incorporate;

DECLARE @Today DATE = GETDATE()

SELECT

prd.ProductID,

prd.Description,

prd.Price,

...

Forget that last post. I'm being a k*ob!. That works now thankyou very much.

I probably should have mentioned that I'm trying to create a view. Doesn't seem to like the DECLARE statement.

USE [Development]

GO

/****** Object: Table [dbo].[Order] Script Date: 03/10/2010 09:38:23 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Order](

[OrderID] [int] IDENTITY(1,1) NOT NULL,

...

Hi Lynn - thanks for that but I still get no rows returned even though there is a record with the date 2010-03-10 in the order date field. Help!