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 ...];