>Hello,
>
>I have trouble working with Date fields in SQL Server 2008. when I use Date type, it returns as Character(8) in queries. So I need to use datetime fields, but obviously the program should not display the time part of the datetime field. Has somebody found a good practice to work around this issue?

Check if this thread Re: SQL Server 2008 Date Field Thread #1379346 Message #1379397 can be of some help.