I have a table in which i have materials and material description field.
I have to compare the material description with the description entered by the user and if the material description in the table contains any
matching word that is entered by the user then that material have to be considered .
1000002 arti goods
1000003 ZACT-ALPRAZOLAM ip
1000004 ZACT ABCD
and user enters description as ZACT-ALPRAZOLAM USP
now i want to compare the description in the table matching the description entered by the user and in the above case i want to consider
material number .. 1000003 and 1000004 as it contains at least one word of the description entered by the user..