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.
Thanks7031

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.

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.

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.I think the like uses regex in which case it would be .*[Cc]ompany.*