Good Morning,


We work with BaaN 5c.

I want in the before program a query extension with a wild card search on the table field tipcs020.seak.
Main table in the display session is tipcs020

before.program: wildcard = "SE" query.extend.where("tipcs020.seak like wildcard")

Can anybody help me in coding this?

Thank you

John

Always try searching first - in this thread (http://www.baanboard.com/baanboard/showthread.php?t=27861&highlight=like+query+extend) you can see an example of using like. So you could use like ".*SE.*" or like "SE.*" depending on what you want your search to look like.

This thread should be moved to the tools forum.