I have to make sure that any inserted Email has the format: "X@Y.Z"
X and Y may only contain letters and numbers and Z can only have Letters.
I tried something like this, but i cant figure out how to limit the Characters for X,Y and Z separately.
Create Table User( Mail varchar check(Mail NOT GLOB '*[^A-Za-z0-9@.]*' AND Mail LIKE '%_@%_._%'));