Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Problem with inserting strings...
0 views
Skip to first unread message
Emil
Nov 7, 2000, 3:00:00 AM11/7/00
to
replace '||' with '+'
"Terje Krång" <te...@dreamscape.no> žķžgĐóķlĨó
news:3a01496c...@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, te...@dreamscape.no
>
0 new messages