• This works!

    create table #test( testtext varchar(30)

    , MyRand varchar(5) DEFAULT(REPLACE( STR( ABS( CHECKSUM( NEWID() ) ) % 10000, 5 ), ' ', '1' ) ) )

    go

    alter table #test add whentext datetime

    go

    insert into #test(testtext,whentext)

    select 'apples',getdate() union all

    select 'grapes',getdate() union all

    select 'bananas',getdate()

    go

    select * from #test

    go