SQL PLUS Spooling with Quotes around field
From: Fraser Boswell <Fraser.Boswell_at_spamme.ed.ac.uk>
Date: Thu, 17 Jun 1999 15:51:31 +0100
Message-ID: <37690B73.B6380D7C_at_spamme.ed.ac.uk>
[Quoted] We're currently running scripts which produce mail merge files, but Word is reading a Text field which is numeric as a Number field. We know this as 000001 is being merged as 1, which isn't what we want. So How can I make sure that Quote marks surround each field in the spooled file? [Quoted] Any ideas?
Date: Thu, 17 Jun 1999 15:51:31 +0100
Message-ID: <37690B73.B6380D7C_at_spamme.ed.ac.uk>
[Quoted] We're currently running scripts which produce mail merge files, but Word is reading a Text field which is numeric as a Number field. We know this as 000001 is being merged as 1, which isn't what we want. So How can I make sure that Quote marks surround each field in the spooled file? [Quoted] Any ideas?
Thanks in advance
Fraser Received on Thu Jun 17 1999 - 16:51:31 CEST