-- Convert Down Level Logon format e.g. domain\username to User Principal Name (UPN) format [email protected]

Down-Level-Logon-To-UPN-Logon.sql

-- Convert Down Level Logon format e.g. domain\username to User Prindipal Name (UPN) format [email protected]
-- The formats are explained here https://msdn.microsoft.com/en-us/library/windows/desktop/aa380525(v=vs.85).aspx
IF OBJECT_ID (N'[dbo].[uFnGetDomainAtFromDomainSlash]', N'FN') IS NOT NULL  
    DROP FUNCTION uFnGetDomainAtFromDomainSlash;  
GO  
CREATE FUNCTION [dbo].[uFnGetDomainAtFromDomainSlash](@AccountNameWithDomainSlash VARCHAR(MAX), @DomainExtension VARCHAR(MAX))  
RETURNS VARCHAR(MAX)
AS   
BEGIN  
    DECLARE @AccountName VARCHAR(MAX),
	@DomainName VARCHAR(MAX)
	SET @AccountName = SUBSTRING ( @AccountNameWithDomainSlash, PATINDEX('%\%',@AccountNameWithDomainSlash) + 1, 100)
	SET @DomainName =  SUBSTRING ( @AccountNameWithDomainSlash, 0, PATINDEX('%\%',@AccountNameWithDomainSlash))
	RETURN CONCAT(@AccountName, '@', @DomainName, @DomainExtension)
END;
GO

-- Usage 
-- This will convert 'wayne-industries\bruce.wayne' to '[email protected]'
SELECT  [dbo].[uFnGetDomainAtFromDomainSlash]('wayne-industries\bruce.wayne', '.gotham')AS AccountNamwWithDomain

you should add a preview of what you want to create that way i will be useful tdo that we can understand..

@ynotcme01000 thanks, good point, done.