All Forums Database
tmcrouse 29 posts Joined 07/14
15 Jul 2014
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 '@'

dnoeth 4628 posts Joined 11/04
15 Jul 2014

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

Dieter

You must sign in to leave a comment.