From: "Chris Leonard" Newsgroups: comp.databases.oracle References: Subject: Re: Oracle x SQL Lines: 47 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: Date: Mon, 8 Sep 2003 17:44:49 -0500 NNTP-Posting-Host: 128.255.4.141 X-Trace: news.uswest.net 1063061089 128.255.4.141 (Mon, 08 Sep 2003 17:44:49 CDT) NNTP-Posting-Date: Mon, 08 Sep 2003 17:44:49 CDT Hello Jorge, The SOUNDEX function in Oracle will return the same values as the SOUNDEX function in SQL Server. To see how to use SOUNDEX to compute the DIFFERENCE function, see http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q100/3/65.asp&NoWebContent=1. -- Cheers, Chris ___________________________________ Chris Leonard, The Database Guy http://www.databaseguy.com Brainbench MVP for Oracle Admin http://www.brainbench.com MCSE, MCDBA, OCP, CIW ___________________________________ "Jorge Pinto" wrote in message news:GAO6b.507$Nx6.84824@news20.bellglobal.com... > Hi Folks, > > I have some stored procedures in Sql and I'm migrating those to Oracle. I > didn't find one with the same idea as DIFFERENCE in SQL. If you don't know > what is the function of difference, I'm explaining.... > DIFFERENCE > Returns the difference between the SOUNDEX values of two character > expressions as an integer. > > Anyone know if we have a function with the same functionality as this one > above in Oracle ?? > > > > Thanks in Advance, > > > > Jorge > >