Hi I am looking to validate a customer name field. I need to only include values that contain the following information: Acceptable customer name example formats: last name, first name Doe, Jane Doe, John Anthony-Smith, Jim Requirements: - customer name is doesn't contain numbers or special characters. There are cases where the name is hyphenated, which is acceptable. I was trying this code but not able to get it to work - select upcase(strip(compbl(COMPRESS(COMPRESS(cust_name, ""~!@#$%^&*()-_=+\|[]{};:'‘’,.<>?/""),'""""')))) from my_data; - Need to confirm that the length for the last and first name have a min length of 1 byte each. I am able to determine the length of the field, not sure how to validate the length prior to the comma and preceding the comma. select LENGTH(CUST_NAME) AS LEN FROM MY_DATA; thanks in advance
... View more
