>I have a character field in which we store dates (format is 01/01/2000) of a persons visit. I would like to select only those that are no further back then todays date. I am using the getdate() function to determine the day. However I cannot get the results to come back correctly.
>
>
>what i am looking for
>
>select * from mytable where ddate >( getdate() - 6 months)

You might want to try...

select * from mytable where covert(datetime, ddate) > (getdate()-180)

BOb