Re: SQL PLUS Spooling with Quotes around field

Just to avoid confusion it is select '"'||fieldname||'"', ...from table (single quote, double quote single quote) not just 4 quotes for anyone interested. Probably not though.

Fraser Boswell wrote:

> I'm running Word 97 but I am getting 1 from 0001 when merging. Must be due to
> a difference in the ODBC drivers.
> However I did the select ''''||fieldname||'''', ...from table and it worked
> fine. So Thanks
>
> Fraser
>
> Chris Weiss wrote:
>
> > Word 97 does not display this behavior. 0001 without quotation marks was
> > merged as 0001. If you have an older version of Word, this might be a
> > problem.
> >
> > Check your spool program.
> >
> > If you need quotations marks you can use two single quotation marks to
> > indicate a single.
> >
> > For example,
> >
> > select '''But''' from dual;
> >
> > If you need double quotation marks, try something like:
> >
> > select '"'||'two'||'"' from dual; <- This has double quotation marks.
> >
> > You could do things like
> >
> > select ''''||fielda||'''' from your table.
> >
> > Christopher Weiss
> > Professional Services Division
> > Compuware Corporation
> >
> > Fraser Boswell <Fraser.Boswell_at_spamme.ed.ac.uk> wrote in message
> > news:37690B73.B6380D7C_at_spamme.ed.ac.uk...
> > > 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?
> > > Any ideas?
> > >
> > > Thanks in advance
> > >
> > > Fraser
> > >
Received on Fri Jun 18 1999 - 10:26:59 CEST