Hi,
I want to check if postal addresses in my database table conform to the below conditions/format. Is it possible to use a single format pattern in REGEX_LIKE for all the conditions or do I need to perform using multiple statements
The entire string cannot be more than 35 characters
Should start with a-z, A-Z or 0-9
Can have space and a special characters (from a selected list) after the first character
Cannot end with space or white space
Cannot have more than two consecutive spaces
Thanks in advance.