I will try DBCC checkdb if it found error and then i will ran DBCC updateusage

Will let you know if this was the solution

ScottPletcher (4/30/2015)

SELECT MONTH(Anniversaire) AS MM, DAY(Anniversaire) AS DD, Anniversaire, Prenom, Nom

FROM Tbl_RH_Pharmacie

WHERE (Anniversaire IS NOT NULL AND Anniversaire <> '') AND

1 = CASE...

Lynn Pettis (4/30/2015)

Try this:

set...

YYYY-MM-DD is the format on the DB

I try this SELECT ISNULL(MONTH(Anniversaire),''),'', Anniversaire FROM Tbl_RH_Pharmacie but got the same error, Am i doing it correctly &