Fuzzy Search...

[Former Member]

Hi,

I would like to know how to incorporate a fuzzy search in a field.

For example... if an user enters TEST* in a selection screen field p_var , I should display all the records which has the p_var starting with TEST..... if the user enters TEST than I should display all the records contains the string TEST

Thanks,

Suresh

[RaymondGiuseppi]

Declare the PARAMETER as a SELECT-OPTIONS.

If only one field should be displayed use NO-EXTENSION and NO INTERVALS options.

Then in your program use SELECT (...) WHERE <field> IN <select-option>

(If you use LIKE instruction you will have to map the "*" into "%")

Regards

[Former Member]

try this,

if p_var CA '*' .

split p_var at '*' into var1 var2.

concatenate 'var1' '%' into var1.

condense var1.

select <fields> from <DB> where

<field> like var1.

else.

concatenate '%' 'var1' '%' into var1.

condense var1.

select <fields> from <DB> where

<field> like var1.

endif.

"<var1> and <var2> are string type variables