Fixing the "date"

[techgnome]

See if this idea works for you - add an expression field to your database...

something like this:

ALTER TABLE [sto_database].[dbo].[Certmast]
ADD NEW_CERT_ISSUE_DATE as RIGHT(REPLICATE('0', 6) + CONVERT(varchar(6), CER_CERT_ISSUE_DATE), 6)
go

now when you do a select from your table, you'll have a new field ... keep in mind, it's read-only though... and its value is driven by the CR_CERT_ISSUE_DATE field, so any updates would need to go against that field.

-tg