The present mechanism is :

1.  Version zero of a document is automatically generated and e-mailed to a user using CDO.

2.  The user edits the document and stores in the database...

"It looks like they never really resolved the xp_Sendmail issue in that thread..." - exactly

I think I'm going to forget it and just...

(It's not the wording that I disagree with.  I think he got the wrong end of the stick, - read the last past of his post i.e. "the query outputs...

Nope.

The @attach_results = 'true' ensures that the query result is sent as an attachment rather than in the body.

Just to clarify, you want to retrieve a number and pad it with leading zeros to ensure the value returned is always 9 characters long ?

If so then maybe you...

Thanks Max, but tried the ANSI output yesterday, it gives me a garbled Hexadecimal mess !

Oh, I was answering this question:

"How can I get the decimal separtor from SQL Server?"

I should have read on a bit further

I...

DECLARE @1 float, @2 float, @DecTest float

SET @1 = 1

SET @2 = 2

SET @DecTest = @1/@2

SELECT Substring(CAST(@DecTest AS varchar),2,1) AS Separator