Re: Problem with inserting strings...

replace '||' with '+'

"Terje Krång" <terje_at_dreamscape.no> ¼¶¼g©ó¶l¥ó news:3a01496c.94819322_at_ns2.qualitynet.net...
> I am trying to make a generic script for Oracle and MS SQL. The script
> is supposed to insert some values in a table.
>
> Example:
>
> insert into TEST (ID, URL) values (0, 'test.asp?page=3&user=4');
>
> This works just fine in MS SQL Server and Oracle v7.3.4, but not in
> Oracle v8.0.
>
> (I can - of course - replace the & with '||'&'||', but that won't work
> in MS SQL Server.)
>
> Does anybody have a nice generic way of doing this?
>
>
> Best Regards,
> Terje Krång, terje_at_dreamscape.no
>
Received on Tue Nov 07 2000 - 09:18:49 CET