In SQL database we need to concatenate 2 fields to display in one and turn them into an email address in the following format
joe.bloggs@.company.co.uk
They are the following: forename & surname
The expression will require a . to be added between the forename & surname and @.company.co.uk at the end.
Anyone help...... ?This should work:
SELECT forename || '.' || surname || '@.company.co.uk' AS [name]
FROM [table]
[WHERE ...];
No comments:
Post a Comment