Regular Expression to validate the field: Field Data should not contain brackets.

Question

Hi all,

[dbo].[Regex]('^[-a-zA-Z0-9,&''.@#/:;]+$',@ClaimantMailingAddressLine1)

above is my regular expression when i am passing '(' or ')'brackets symbol it is nt returnig error...

please hw 2 do this....

and please teach me how to eliminate perticular character is a invalid thing. rite now wt ever symbol is present in brackets i.e [ ] its a valid so similarly how to eliminate the pericular words or letters.

Thanks in Advance.........

Please advise

Answer 1

I can't tell what you're doing, but you can match everything except what's in the brackets of a regular expression by using [^abc] where abc are the characters you do not want to match.