Access Format Equivalent

From: Bryan (anonymous_at_discussions.microsoft.com)
Date: 06/13/04 

Date: Sun, 13 Jun 2004 13:40:11 -0700

Hello:

What would the equivalent syntax be to format the
following in SQL as can be done in Access.

Format("000000",employee) to return 012345 from 12345