Concatenation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Concatenation

  1. #1
    Join Date
    Apr 2005
    Posts
    2

    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
    Attached Images Attached Images

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width