>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

Einar,
This is what I am doing:

where PmntDueDate >= CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, GETDATE())))

Basically my PmntDueDate fields could be any date/time combination, and this runs in a DTS script every morning at 7AM to find the records that came due that day, regardless of the time.