create email address from first and last name in sql

Solutions on MaxInterview for create email address from first and last name in sql by the best coders in the world

Search
showing results for - "create email address from first and last name in sql"
Oona
19 Jan 2017
1# NB: This creates email addresses with the format
2# first_name.last_name@company_name.com
3# Name of table = names_table
4# Name of column containing names = full_name
5# Simply change the table and column name to what corresponds with your dataset
6
7WITH temp_table AS (
8	SELECT LEFT(full_name, STRPOS(primary_poc, ' ') -1 ) AS first_name,  
9  			RIGHT(full_name, LENGTH(primary_poc) - STRPOS(primary_poc, ' ')) AS last_name, name
10	FROM names_table)
11
12SELECT CONCAT(first_name, '.', last_name, '@', 'company_name.com')
13FROM temp_table;
similar questions
get the user name and domain name from an email addressget first name and last name from full name string in sqlsql statement show all emails with domehow to send a query result as an email body sql serversql query to select records entered in last 24 hourssql server set default value equal to auto incrementwrite a query in sql to find the data of employees whose last name is 27snares 27sql select last idhow to combine first and last nae into one columb sqlsql query to find duplicate email addresssql distinct email regexsql get last idsql hello 2c 5bfirstname 5d 5blastname 5djoin first name and last name sqlms sql connection string with username and passwordsql query for login with email or usernameget all employees first name department id with department id of 100 in sqlemail datatype in sqlget all employees first name department id with department id of in sqlget first n letter of department name in sql
queries leading to this page
create email address from first and last name in sqlcreate email address from first and last name in sql