Not ideal, but you can nest the replace statments for a quick fix: replace(replace(replace(replace('Smith (Hon. Member)John','(',''),')',''),'.',''),' ','') produces: SmithHonMemberJohn otherwise you could always write a function to remove any non alphanumeric characters. I don't know of any pattern matching within the replace statement though.

Probably more than one way to go about something like this, and none of which are really very clean. Basis of anything is, that if 1441 matches the start of the mobile number then it can't be 1 for U.S. You could match these back in 4 iterations, starting with the 4 digit codes first, then exluding what you had matched when you do your 3 digit matches and so on. You could code this on the fly, but would overcomplicate it really, could you add another field onto your text_status table, and update it with the iddcode where you get a match on all 4 digit iddcodes. Then update the field with all matching 3 digit iddcodes where the field is still null, then 2 digit, then 1 digit.

could you use =SUM(IIF(fields!GENDER.value = "MALE", 1, 0)) =SUM(IIF(fields!GENDER.value = "FEMALE", 1, 0))

If you stored your values in the same format eg. A01-50, A02-50, A09-10, A10-50 Then a max on the column would bring back the A10-50 you wanted.