Hey there,

i'm joining a smalldatetime field and a nvarchar field to be a smalldatetime
using the following

Code:
 CONVERT(smalldatetime, CONVERT(CHAR(10), dDespatchDate, 111) + ' ' + sSTA)

when i combine a date 02/04/2007 with a string 14:55 it results in 02/04/2007 14:55:00

however when i combine a date 02/04/2007 with a string 00:00 it results in 02/04/2007 with no time attached...

can someone tell me why is this