>>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.
Indeed it helped. I have to use "SQL Server Native Client 10.0" in StringConnect.
Christian Isberner
Software Consultant