Home Forums SQL Server 2008 T-SQL (SS2K8) Is Format Functions Avail in SQl Server? RE: Is Format Functions Avail in SQl Server?
Stewart "Arturius" Campbell
SSC Guru
Points: 72484
More actions
January 25, 2011 at 7:39 am
#1277840
You could try:
RIGHT('0000'+CONVERT(VARCHAR(5),ColumnName),5)
____________________________________________Space, the final frontier? not any more...All limits henceforth are self-imposed.“libera tute vulgaris ex”