Concatenation

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 "+"?


THX

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.

Tamil