Re: How to insert an & in a table with an SQL-statement.

Hi,

like already stated by Thomas Kyte, the most preferable way to do this is : set scan off

but there is another trick, which might be handy in rare cases :

update tableX
set field = 'text&' || 'text'

greetings,
Thierry Poels
DBA & Unix System Manager for VTB-VAB
http://www.vab.be/

Marten Tacoma wrote in message <7007bl$5cg$1_at_server1.adam.ixe.net>...
>Hello..
>
>Could anyone tell me how to insert a & in a field without it promts me for
>a variable.
>I need to send an escape-sequence to a printer to change its settings.
>We are working with forms 3.x (or omething like that), and this version
does
>not accept escape sequensys. So I put al nonsenstext in a field en then run
>an sql like this:
>
>upadate tableX
>set field=' xx&yyy'
>where field='nonsenstext'
>/
>
>And the & makes the sql ask me for a variable. But what I want is tho put
an
>*hard* & in the field.
>
>Anny help ?
>
>Marten Tacoma.
>
>mtacoma_at_doge.nl
>
>
>
>
Received on Wed Oct 14 1998 - 03:11:55 CDT