Re: Oracle x SQL
From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Mon, 8 Sep 2003 17:44:49 -0500
Message-ID: <BD77b.91$Dh2.53371_at_news.uswest.net>
Date: Mon, 8 Sep 2003 17:44:49 -0500
Message-ID: <BD77b.91$Dh2.53371_at_news.uswest.net>
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" <jorgep_at_sympatico.ca> wrote in message news:GAO6b.507$Nx6.84824_at_news20.bellglobal.com...Received on Tue Sep 09 2003 - 00:44:49 CEST
> 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
>
>