[SQL] Format function - need help

I have this piece of SQL code coming from Access:

Format([Jobnumber2],"00000") AS [Job Number]

What is the translation in SQL server language? I can't find the equivalent of the Format function!

Otherwise, is there a way to use ASP code to format the number in the way I'd like to?

Cheers,

C

anybody knows?|||RIGHT('00000'+CAST(JobNumber2 AS varchar),5) AS [Job Number]|||Thanks very much for your help Motley!