Can someone please tell me how to use the string and substring fuctions to remove an integer from a concat statement.? I'm befuddled.
Field 5 is where I'm sending a rule from checkboxes, that if checked (or yes) read the text box and add an integer to it, then a tilde " concat(field5, field4, "`")"
Where I'm having difficulty is if my check box is later checked as no, how to remove the interger value.
I know this is basic stuff, but cant get it to behave.