topic Re: Fuzzy Text search in Application Development and Automation Discussions

Fuzzy Text search

Former Member — Mon, 26 Nov 2007 08:56:53 GMT

Hi,

We have requierment to compare the employee names i.e., for eg: in database we have names as follows:

srinivas rao

sreenivas

reddy srinevas....

If user entere name as srinivas for searching then the query should show all above names as output.

In oracle we have function called FUZZY. Is there any SAP function similar to this.?

Former Member — Mon, 26 Nov 2007 08:59:28 GMT

Hi Srinivas,

There is no function or statement in SAP to check for FUZZY logic but You have SEARCH statement to search for string in a string.

Check this link for SEARCH statement.

Thanks,

Vinay

Former Member — Tue, 27 Nov 2007 06:34:47 GMT

Thnx for your advise.

Can we use the Oracle FUZZY function in our SAP(4.7) through native SQL statement?

Former Member — Tue, 27 Nov 2007 06:40:00 GMT

Hi Srinivas,

Yes, You can do with NATIVE SQL statements but the table should exist in your Oracle database.

To use a Native SQL statement, you must precede it with the EXEC SQL statement, and follow it with the ENDEXEC statement as follows:

EXEC SQL [PERFORMING <form>].

ENDEXEC.

Thanks,

Vinay