Hi all,

I am trying to transform a numeric amount in SQL Server 2000. What I started with is this:
-119.760000000000
What I have now is this:
-119.76
What I need when I am done is this:
0000011976
I know there is a function or method to accomplish my goal.
Can anyone help?