see the sample...

select orderid from orders where Convert(char(10),orderdate,112) = '19960829'

gives this...

SELECT	[Id]
FROM	[MyTable]
WHERE	CONVERT(CHAR(10),DateField,112) = @DateField

Code 112 in convert means ISO, but you can use 110 for USA mm-dd-yy, see BOL.

[ ]'s
Peter

>Consider the following select statement:
>

>SELECT	[Id]
>FROM	[MyTable]
>WHERE	YEAR(DateField) = YEAR(@DateField) AND
>	MONTH(DateField) = MONTH(@DateField) AND
>	DAY(DateField) = DAY(@DateField)
>

>
>I want to select the records that have the same date as the parameter, but I do not care about the time part of the field or parameter.
>Is there another (better) way of doing this?
>
>Thanks,
>Einar