Hi,
Using Baan IV becs client tool ...
Does anyone have an idea how to use the Query menu command from Labels Tools in order to get all the labels with label description like '%Company%' ?
For example, 'Company', 'Original company', etc.
See also the screen.
Thanks

Use something like .*Company.* - of course company will have to have the right case. So this should find anything with Company in it, but will not find company. At least that is how I recall it works.

__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.

Thanks Mark. That works. I wonder now how to modify in order to get both company and Company (with respect to capital letters). Anyway the answer is useful.
PS: I thought the form takes the SQL special signs for LIKE operator (that is, % instead of *)

You might want to check the help - I think the ? is for any character - but you could just use .*ompany.*. Back in the day depending on what I was doing I just might write an easy sql to query the tables that way - still using like .* in the like portion of the query.

__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.

I think the like uses regex in which case it would be .*[Cc]ompany.*

__________________

Also read Luke 24:4-8

---

After that you can find many answers on Infor, LN, BaanIV, BaanV, InforLN and ION and even some questions asked here on baanboard.com

---