Fuzzy Text search

[Former Member]

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]

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]

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.

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/search.htm

Thanks,

Vinay

[Former Member]

Thnx for your advise.

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

[Former Member]

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>].

<Native SQL statement>

ENDEXEC.

Thanks,

Vinay