Searching for a value inside of a string of data - baq

Epicor ERP 10
1

We have 2 fields…1 field has a value and the 2nd field has a string of data. Is there an easy way you can use the baq functions to have the system compare the 1st field to verify if that value or data is contained in the string. For example - here is a part description: Widget ABC 26" x 37". Then we have a part attribute for part Length: 26". So, to verify that the correct length (26") is in the description I want to query the part length to see if the Part Description contains that value within the string. Possible? Thanks?

2

This calculated field will do that for you

image
image936×624 31.1 KB

image

3

Or if your PartNum field isn’t already text:

iif(PartDescription LIKE '%' + convert(varchar, PartNum) + '%', 1,0)
4

thanks guys - I will try this!