Hi, I'm running an application in Visual Basic 6.0 with a SQL 2000, but I have recently migrated to oracle 10g. Most things are running OK. but I have a problem when I try to concatenate strings. To do so with Sql 2000 I have to use a + operator, but with Oracle I am impelled to use a || operator. Since I can't change the source code of the application I must find alternative solutions.
I need Oracle to understand that "+" should be used as a "||", so as to concatenate strings.
Is there any other solution than a user defined operator called "+"?
Try TRANSLATE function. I am not sure this will work for you.
You should continue to work with SQL Server.
You should not choose Oracle.
Click Here to Expand Forum to Full Width