I'm not that knowledgeable with T-SQL. Post this question in the SQL Server forum.
>Thank you.
>Alternately, would it be possible to convert it prior to insertion by use of a trigger or stored procedure?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer