How can i add (-) hyphin in CNIC ?

Apr 22 2019 7:29 AM

hi every one

i have a textbox of CNIC i want when user either Enter CNIC 41111-8888888-9 or 4111188888889 as this pattern but when this one insert in my SQL table so pattern should be 41111-8888888-9

i want to do this using Query

thanks in advance?

Answers (1)

check sql validation

Unable to import severals Tables from an Access Data Base