Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Combining FUZZY and LIKE

Suppose I have a column with names, one of them is Peter.

When doing:

SELECT * FROM "NEO_123456789ABCDE"."MYTABLE1" WHERE contains(name,'%pete%')

or

SELECT * FROM "NEO_123456789ABCDE"."MYTABLE1" WHERE contains(name,'%pete%', FUZZY(0.7))

or

SELECT * FROM "NEO_123456789ABCDE"."MYTABLE1" WHERE contains(name,'peteX', FUZZY(0.7))

I get the desired result Peter.

But

SELECT * FROM "NEO_123456789ABCDE"."MYTABLE1" WHERE contains(name,'%peteX%', FUZZY(0.7))

doesn't work. I just get an empty string.

So combining the wildcards % and the fuzzy search doesn't seem to work in my example.

I'm executing this query from my XS application with AJAX so that it is executed "as-you-type".

So if you enter "p" or "pe" or "pet" it should return"Peter". But also if you misspell it as "petr" for example.

Does anybody have a suggestion?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question