2006-07-28 00:00:00

This is the result I get in Word as I handle a document that merges data
from the database.   The field ĞDate_Fin_Membreğ  returns me this result
even if the query stipulates
WHERE      (dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101)). I have also tried other types of
conversion without any success.  I just need the date not the following
hours, minutes and seconds.
thanks

You might be using CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101)
only for checking in where clause, you will have to specify the same in
Select columns as well.

something like this:
Select
CONVERT(Char(10), dbo.Membre.Date_Fin_Membre, 101) from XYZTable
Where
dbo.Membre.Date_Fin_Membre = CONVERT(Char(10),
dbo.Membre.Date_Fin_Membre, 101))

Regards,

Thanks, it solved my problem.

*** Sent via Developersdex http://www.droptable.com ***