Re: ENCLOSE QUOTE CHAR. IN SQL ?

select '''' || table.refnbr || '''' from table; You need to escape the quote by using an extra quote. Hence your string is missing a quote.

Hth,

--
Sybrand Bakker, Oracle DBA
Joël Dessart <jocky_at_bigfoot.com> wrote in message news:3869C8D6.27ABBD6E_at_bigfoot.com...
> Hi !
>
> I want to enclose the quote char before and
> after a reference number in a SQL statement.
>
> E.g. : ref. nbr= 0026121.07
> After SQL: '0026121.07'
>
> How could I do this in script since something
> like: select ''' || table.refnbr || ''' from table;
> does not work ?
>
> Is there a mean to say that the quote must be
> kept as character and not as limit of an
> explicit string in this query (kind of ESCAPE char
> for LIKE operator...) ?
>
> Thanks a lot !
>
> Joel
> mailto:jocky_at_bigfoot.com
>
Received on Wed Dec 29 1999 - 03:40:31 CST