• declare @t datetime, @h char(4)

    set @t = '20040702'

    set @h = '0800'

    select @t, @t + STUFF(@h,3,0,':')



    --Jonathan