Need help formatting Float data type for leading zeros

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

Date: Tue, 13 Apr 2004 06:01:06 -0700

I have an existing query in Access 2000 that I'm converting to a SQL view. One of my returned columns current syntax is:

Format([tblFoo.NoteAmount]), "00000000.00") AS NoteAmount

If I give it a value of 10400.56 it will give me 00010400.56 as NoteAmount in the resulting data set.
If I give it a value of 94.00 it will give me 00000094.00 as NoteAmount in the resulting data set.

I can't seem to port this to a view. the "FORMAT" function isn't allowed and I can't get the NoteAmount which is a Float data type to cast or convert the way I want it.

Any ideas?