Format persisted column as padded integer string in MS SQL Server 2008
How would I create the formula for adding the two columns below togehter, the first must be padded to 5 characters:

ID (INT)
RefNum (STRING)

I went for format(ID,"00000") & RefNum, but it doesn't work, any ideas please?
Format persisted column as padded integer string in MS SQL Server 2008
===

How would I create the formula for adding the two columns below togehter, the first must be padded to 5 characters:

ID (INT)
RefNum (STRING)

I went for format(ID,"00000") & RefNum, but it doesn't work, any ideas please?