Alvinlee
19th January 2007, 18:40
Hi, All

I would like to build a extend query to filter item master's description

For example, pattern : "apple"

expected results : all item description contain "apple" (Not only start with) will be listed out

How can I do it ?

Grateful if provide me the solution

AL

bigjack
19th January 2007, 19:14
You can use the "like" clause in your where condition. Check the manuals for detailed help

Alvinlee
20th January 2007, 17:25
thanks bigjack