Peter,
Thanks for your reply. I have to look into the convert funtion more. Do you think your method is better, i.e., faster than my method?

Thanks,
Einar

>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