You'll have to use the Convert() function to remove the time part, the datetime datatype always returns the time part as well. For your search, you'll have to remove the time part, because to SQL Server '4/11/2003 9:12:20 AM' is not the same as '4/11/2003'.

declare @dt datetime
set @dt = '4/11/2003 9:12:20 AM'

-- return date only as a string
select Convert(varchar(12), @dt,101)
-- remove time part
select Cast(Convert(varchar(12), @dt,101) as datetime)

Roman

>Hi,
>
>I have a datetime field, when I query this field I get something like this
>4/11/2003 9:12:20 AM
>
>I would like to return only the full date portion of this field.
>
>
>Also,
>
>When I perform a search on this field... if I look for 04/11/2003 will I get the appropriate row?
>
>
>Thanks,
>
>Sorry if the question is worded badly.. Im trying to get this done..
>
>Thanks,
>
>Alvin