format for email in create table

Database
Enthusiast

format for email in create table

I see that I can format 999-999-9999 for a phone but how do I format for email when doing a create table? I have email varchar(50). Can I do format '@'

1 REPLY
Junior Contributor

Re: format for email in create table

Why do you want to format an email address, it's only a string?

A valid email should already include the @ and if you stored both parts separately you simply concat:

local_part || '@' || domain_part