Apparently in the time past, someone entered and ShipTo number that has alphabet characters. How can I restrict to not include those? I’ve been working on this for several hours and figured it was time to ask for help.
You could use a regular expression within a BPM on the update method to validate the field matches the syntax you’ve defined.
1 Like
That would be good going forward. What I was meaning, and I didn’t specify this, is restrict this within a BAQ.
Use a calculated field…
try_convert(int, ShipToNum)
Then filter BAQ for calculated field > 0
@bmgarver I tried similar earlier, just without the filter. I get this error. Conversion failed when converting the nvarchar value ‘(nw)04066’ to data type int.
you are using try_convert and not convert, correct? try_convert should not give an error if it fails, just return an empty value.
1 Like
My mistake I though you said to try! LOL! I used it and it worked. Thanks!