BEGIN
CREATE TABLE  #letters ( WelderId varchar(3) )
INSERT INTO #letters VALUES ('A1')
INSERT INTO #letters VALUES ('A2')
INSERT INTO #letters VALUES ('A3')
INSERT INTO #letters VALUES ('A4')
INSERT INTO #letters VALUES ('A5')
INSERT INTO #letters VALUES ('A6')
INSERT INTO #letters VALUES ('A7')
INSERT INTO #letters VALUES ('A8')
INSERT INTO #letters VALUES ('A9')
INSERT INTO #letters VALUES ('A10')
INSERT INTO #letters VALUES ('A11')
INSERT INTO #letters VALUES ('A12')
INSERT INTO #letters VALUES ('A13')
INSERT INTO #letters VALUES ('A14')
INSERT INTO #letters VALUES ('A15')
INSERT INTO #letters VALUES ('A16')
INSERT INTO #letters VALUES ('A17')
INSERT INTO #letters VALUES ('A18')
INSERT INTO #letters VALUES ('A19')
INSERT INTO #letters VALUES ('A20')
INSERT INTO #letters VALUES ('A21')
INSERT INTO #letters VALUES ('A22')
INSERT INTO #letters VALUES ('A23')
INSERT INTO #letters VALUES ('A24')
INSERT INTO #letters VALUES ('A25')
INSERT INTO #letters VALUES ('A26')
INSERT INTO #letters VALUES ('A27')
INSERT INTO #letters VALUES ('A28')
INSERT INTO #letters VALUES ('A29')
INSERT INTO #letters VALUES ('A30')
INSERT INTO #letters VALUES ('A31')
INSERT INTO #letters VALUES ('A32')
INSERT INTO #letters VALUES ('A33')
INSERT INTO #letters VALUES ('A34')
INSERT INTO #letters VALUES ('A35')
INSERT INTO #letters VALUES ('A36')
INSERT INTO #letters VALUES ('A37')
INSERT INTO #letters VALUES ('A38')
INSERT INTO #letters VALUES ('A39')
INSERT INTO #letters VALUES ('A40')
INSERT INTO #letters VALUES ('A41')
INSERT INTO #letters VALUES ('A42')
INSERT INTO #letters VALUES ('A43')
INSERT INTO #letters VALUES ('A44')
INSERT INTO #letters VALUES ('A45')
INSERT INTO #letters VALUES ('A46')
INSERT INTO #letters VALUES ('A47')
INSERT INTO #letters VALUES ('A48')
INSERT INTO #letters VALUES ('A49')
INSERT INTO #letters VALUES ('A50')
INSERT INTO #letters VALUES ('A51')
INSERT INTO #letters VALUES ('A52')
INSERT INTO #letters VALUES ('A53')
INSERT INTO #letters VALUES ('A54')
INSERT INTO #letters VALUES ('A55')
INSERT INTO #letters VALUES ('A56')
INSERT INTO #letters VALUES ('A57')
INSERT INTO #letters VALUES ('A58')
INSERT INTO #letters VALUES ('A59')
INSERT INTO #letters VALUES ('A60')
INSERT INTO #letters VALUES ('A61')
INSERT INTO #letters VALUES ('A62')
INSERT INTO #letters VALUES ('A63')
INSERT INTO #letters VALUES ('A64')
INSERT INTO #letters VALUES ('A65')
INSERT INTO #letters VALUES ('A66')
INSERT INTO #letters VALUES ('A67')
INSERT INTO #letters VALUES ('A68')
INSERT INTO #letters VALUES ('A69')
INSERT INTO #letters VALUES ('A70')
INSERT INTO #letters VALUES ('A71')
INSERT INTO #letters VALUES ('A72')
INSERT INTO #letters VALUES ('A73')
INSERT INTO #letters VALUES ('A74')
INSERT INTO #letters VALUES ('A75')
INSERT INTO #letters VALUES ('A76')
INSERT INTO #letters VALUES ('A77')
INSERT INTO #letters VALUES ('A78')
INSERT INTO #letters VALUES ('A79')
INSERT INTO #letters VALUES ('A80')
INSERT INTO #letters VALUES ('A81')
INSERT INTO #letters VALUES ('A82')
INSERT INTO #letters VALUES ('A83')
INSERT INTO #letters VALUES ('A84')
INSERT INTO #letters VALUES ('A85')
INSERT INTO #letters VALUES ('A86')
INSERT INTO #letters VALUES ('A87')
INSERT INTO #letters VALUES ('A88')
INSERT INTO #letters VALUES ('A89')
INSERT INTO #letters VALUES ('A90')
INSERT INTO #letters VALUES ('A91')
INSERT INTO #letters VALUES ('A92')
INSERT INTO #letters VALUES ('A93')
INSERT INTO #letters VALUES ('A94')
INSERT INTO #letters VALUES ('A95')
INSERT INTO #letters VALUES ('A96')
INSERT INTO #letters VALUES ('A97')
INSERT INTO #letters VALUES ('A98')
INSERT INTO #letters VALUES ('A99')
INSERT INTO #letters VALUES ('B1')
INSERT INTO #letters VALUES ('B2')
INSERT INTO #letters VALUES ('B3')
INSERT INTO #letters VALUES ('B4')
INSERT INTO #letters VALUES ('B5')
INSERT INTO #letters VALUES ('B6')
INSERT INTO #letters VALUES ('B7')
INSERT INTO #letters VALUES ('B8')
INSERT INTO #letters VALUES ('B9')
INSERT INTO #letters VALUES ('B10')
INSERT INTO #letters VALUES ('B11')
INSERT INTO #letters VALUES ('B12')
INSERT INTO #letters VALUES ('B13')
INSERT INTO #letters VALUES ('B14')
INSERT INTO #letters VALUES ('B15')
INSERT INTO #letters VALUES ('B16')
INSERT INTO #letters VALUES ('B17')
INSERT INTO #letters VALUES ('B18')
INSERT INTO #letters VALUES ('B19')
INSERT INTO #letters VALUES ('B20')
INSERT INTO #letters VALUES ('B21')
INSERT INTO #letters VALUES ('B22')
INSERT INTO #letters VALUES ('B23')
INSERT INTO #letters VALUES ('B24')
INSERT INTO #letters VALUES ('B25')
INSERT INTO #letters VALUES ('B26')
INSERT INTO #letters VALUES ('B27')
INSERT INTO #letters VALUES ('B28')
INSERT INTO #letters VALUES ('B29')
INSERT INTO #letters VALUES ('B30')
INSERT INTO #letters VALUES ('B31')
INSERT INTO #letters VALUES ('B32')
INSERT INTO #letters VALUES ('B33')
INSERT INTO #letters VALUES ('B34')
INSERT INTO #letters VALUES ('B35')
INSERT INTO #letters VALUES ('B36')
INSERT INTO #letters VALUES ('B37')
INSERT INTO #letters VALUES ('B38')
INSERT INTO #letters VALUES ('B39')
INSERT INTO #letters VALUES ('B40')
INSERT INTO #letters VALUES ('B41')
INSERT INTO #letters VALUES ('B42')
INSERT INTO #letters VALUES ('B43')
INSERT INTO #letters VALUES ('B44')
INSERT INTO #letters VALUES ('B45')
INSERT INTO #letters VALUES ('B46')
INSERT INTO #letters VALUES ('B47')
INSERT INTO #letters VALUES ('B48')
INSERT INTO #letters VALUES ('B49')
INSERT INTO #letters VALUES ('B50')
INSERT INTO #letters VALUES ('B51')
INSERT INTO #letters VALUES ('B52')
INSERT INTO #letters VALUES ('B53')
INSERT INTO #letters VALUES ('B54')
INSERT INTO #letters VALUES ('B55')
INSERT INTO #letters VALUES ('B56')
INSERT INTO #letters VALUES ('B57')
INSERT INTO #letters VALUES ('B58')
INSERT INTO #letters VALUES ('B59')
INSERT INTO #letters VALUES ('B60')
INSERT INTO #letters VALUES ('B61')
INSERT INTO #letters VALUES ('B62')
INSERT INTO #letters VALUES ('B63')
INSERT INTO #letters VALUES ('B64')
INSERT INTO #letters VALUES ('B65')
INSERT INTO #letters VALUES ('B66')
INSERT INTO #letters VALUES ('B67')
INSERT INTO #letters VALUES ('B68')
INSERT INTO #letters VALUES ('B69')
INSERT INTO #letters VALUES ('B70')
INSERT INTO #letters VALUES ('B71')
INSERT INTO #letters VALUES ('B72')
INSERT INTO #letters VALUES ('B73')
INSERT INTO #letters VALUES ('B74')
INSERT INTO #letters VALUES ('B75')
INSERT INTO #letters VALUES ('B76')
INSERT INTO #letters VALUES ('B77')
INSERT INTO #letters VALUES ('B78')
INSERT INTO #letters VALUES ('B79')
INSERT INTO #letters VALUES ('B80')
INSERT INTO #letters VALUES ('B81')
INSERT INTO #letters VALUES ('B82')
INSERT INTO #letters VALUES ('B83')
INSERT INTO #letters VALUES ('B84')
INSERT INTO #letters VALUES ('B85')
INSERT INTO #letters VALUES ('B86')
INSERT INTO #letters VALUES ('B87')
INSERT INTO #letters VALUES ('B88')
INSERT INTO #letters VALUES ('B89')
INSERT INTO #letters VALUES ('B90')
INSERT INTO #letters VALUES ('B91')
INSERT INTO #letters VALUES ('B92')
INSERT INTO #letters VALUES ('B93')
INSERT INTO #letters VALUES ('B94')
INSERT INTO #letters VALUES ('B95')
INSERT INTO #letters VALUES ('B96')
INSERT INTO #letters VALUES ('B97')
INSERT INTO #letters VALUES ('B98')
INSERT INTO #letters VALUES ('B99')
INSERT INTO #letters VALUES ('C1')
INSERT INTO #letters VALUES ('C2')
INSERT INTO #letters VALUES ('C3')
INSERT INTO #letters VALUES ('C4')
INSERT INTO #letters VALUES ('C5')
INSERT INTO #letters VALUES ('C6')
INSERT INTO #letters VALUES ('C7')
INSERT INTO #letters VALUES ('C8')
INSERT INTO #letters VALUES ('C9')
INSERT INTO #letters VALUES ('C10')
INSERT INTO #letters VALUES ('C11')
INSERT INTO #letters VALUES ('C12')
INSERT INTO #letters VALUES ('C13')
INSERT INTO #letters VALUES ('C14')
INSERT INTO #letters VALUES ('C15')
INSERT INTO #letters VALUES ('C16')
INSERT INTO #letters VALUES ('C17')
INSERT INTO #letters VALUES ('C18')
INSERT INTO #letters VALUES ('C19')
INSERT INTO #letters VALUES ('C20')
INSERT INTO #letters VALUES ('C21')
INSERT INTO #letters VALUES ('C22')
INSERT INTO #letters VALUES ('C23')
INSERT INTO #letters VALUES ('C24')
INSERT INTO #letters VALUES ('C25')
INSERT INTO #letters VALUES ('C26')
INSERT INTO #letters VALUES ('C27')
INSERT INTO #letters VALUES ('C28')
INSERT INTO #letters VALUES ('C29')
INSERT INTO #letters VALUES ('C30')
INSERT INTO #letters VALUES ('C31')
INSERT INTO #letters VALUES ('C32')
INSERT INTO #letters VALUES ('C33')
INSERT INTO #letters VALUES ('C34')
INSERT INTO #letters VALUES ('C35')
INSERT INTO #letters VALUES ('C36')
INSERT INTO #letters VALUES ('C37')
INSERT INTO #letters VALUES ('C38')
INSERT INTO #letters VALUES ('C39')
INSERT INTO #letters VALUES ('C40')
INSERT INTO #letters VALUES ('C41')
INSERT INTO #letters VALUES ('C42')
INSERT INTO #letters VALUES ('C43')
INSERT INTO #letters VALUES ('C44')
INSERT INTO #letters VALUES ('C45')
INSERT INTO #letters VALUES ('C46')
INSERT INTO #letters VALUES ('C47')
INSERT INTO #letters VALUES ('C48')
INSERT INTO #letters VALUES ('C49')
INSERT INTO #letters VALUES ('C50')
INSERT INTO #letters VALUES ('C51')
INSERT INTO #letters VALUES ('C52')
INSERT INTO #letters VALUES ('C53')
INSERT INTO #letters VALUES ('C54')
INSERT INTO #letters VALUES ('C55')
INSERT INTO #letters VALUES ('C56')
INSERT INTO #letters VALUES ('C57')
INSERT INTO #letters VALUES ('C58')
INSERT INTO #letters VALUES ('C59')
INSERT INTO #letters VALUES ('C60')
INSERT INTO #letters VALUES ('C61')
INSERT INTO #letters VALUES ('C62')
INSERT INTO #letters VALUES ('C63')
INSERT INTO #letters VALUES ('C64')
INSERT INTO #letters VALUES ('C65')
INSERT INTO #letters VALUES ('C66')
INSERT INTO #letters VALUES ('C67')
INSERT INTO #letters VALUES ('C68')
INSERT INTO #letters VALUES ('C69')
INSERT INTO #letters VALUES ('C70')
INSERT INTO #letters VALUES ('C71')
INSERT INTO #letters VALUES ('C72')
INSERT INTO #letters VALUES ('C73')
INSERT INTO #letters VALUES ('C74')
INSERT INTO #letters VALUES ('C75')
INSERT INTO #letters VALUES ('C76')
INSERT INTO #letters VALUES ('C77')
INSERT INTO #letters VALUES ('C78')
INSERT INTO #letters VALUES ('C79')
INSERT INTO #letters VALUES ('C80')
INSERT INTO #letters VALUES ('C81')
INSERT INTO #letters VALUES ('C82')
INSERT INTO #letters VALUES ('C83')
INSERT INTO #letters VALUES ('C84')
INSERT INTO #letters VALUES ('C85')
INSERT INTO #letters VALUES ('C86')
INSERT INTO #letters VALUES ('C87')
INSERT INTO #letters VALUES ('C88')
INSERT INTO #letters VALUES ('C89')
INSERT INTO #letters VALUES ('C90')
INSERT INTO #letters VALUES ('C91')
INSERT INTO #letters VALUES ('C92')
INSERT INTO #letters VALUES ('C93')
INSERT INTO #letters VALUES ('C94')
INSERT INTO #letters VALUES ('C95')
INSERT INTO #letters VALUES ('C96')
INSERT INTO #letters VALUES ('C97')
INSERT INTO #letters VALUES ('C98')
INSERT INTO #letters VALUES ('C99')
INSERT INTO #letters VALUES ('D1')
INSERT INTO #letters VALUES ('D2')
INSERT INTO #letters VALUES ('D3')
INSERT INTO #letters VALUES ('D4')
INSERT INTO #letters VALUES ('D5')
INSERT INTO #letters VALUES ('D6')
INSERT INTO #letters VALUES ('D7')
INSERT INTO #letters VALUES ('D8')
INSERT INTO #letters VALUES ('D9')
INSERT INTO #letters VALUES ('D10')
INSERT INTO #letters VALUES ('D11')
INSERT INTO #letters VALUES ('D12')
INSERT INTO #letters VALUES ('D13')
INSERT INTO #letters VALUES ('D14')
INSERT INTO #letters VALUES ('D15')
INSERT INTO #letters VALUES ('D16')
INSERT INTO #letters VALUES ('D17')
INSERT INTO #letters VALUES ('D18')
INSERT INTO #letters VALUES ('D19')
INSERT INTO #letters VALUES ('D20')
INSERT INTO #letters VALUES ('D21')
INSERT INTO #letters VALUES ('D22')
INSERT INTO #letters VALUES ('D23')
INSERT INTO #letters VALUES ('D24')
INSERT INTO #letters VALUES ('D25')
INSERT INTO #letters VALUES ('D26')
INSERT INTO #letters VALUES ('D27')
INSERT INTO #letters VALUES ('D28')
INSERT INTO #letters VALUES ('D29')
INSERT INTO #letters VALUES ('D30')
INSERT INTO #letters VALUES ('D31')
INSERT INTO #letters VALUES ('D32')
INSERT INTO #letters VALUES ('D33')
INSERT INTO #letters VALUES ('D34')
INSERT INTO #letters VALUES ('D35')
INSERT INTO #letters VALUES ('D36')
INSERT INTO #letters VALUES ('D37')
INSERT INTO #letters VALUES ('D38')
INSERT INTO #letters VALUES ('D39')
INSERT INTO #letters VALUES ('D40')
INSERT INTO #letters VALUES ('D41')
INSERT INTO #letters VALUES ('D42')
INSERT INTO #letters VALUES ('D43')
INSERT INTO #letters VALUES ('D44')
INSERT INTO #letters VALUES ('D45')
INSERT INTO #letters VALUES ('D46')
INSERT INTO #letters VALUES ('D47')
INSERT INTO #letters VALUES ('D48')
INSERT INTO #letters VALUES ('D49')
INSERT INTO #letters VALUES ('D50')
INSERT INTO #letters VALUES ('D51')
INSERT INTO #letters VALUES ('D52')
INSERT INTO #letters VALUES ('D53')
INSERT INTO #letters VALUES ('D54')
INSERT INTO #letters VALUES ('D55')
INSERT INTO #letters VALUES ('D56')
INSERT INTO #letters VALUES ('D57')
INSERT INTO #letters VALUES ('D58')
INSERT INTO #letters VALUES ('D59')
INSERT INTO #letters VALUES ('D60')
INSERT INTO #letters VALUES ('D61')
INSERT INTO #letters VALUES ('D62')
INSERT INTO #letters VALUES ('D63')
INSERT INTO #letters VALUES ('D64')
INSERT INTO #letters VALUES ('D65')
INSERT INTO #letters VALUES ('D66')
INSERT INTO #letters VALUES ('D67')
INSERT INTO #letters VALUES ('D68')
INSERT INTO #letters VALUES ('D69')
INSERT INTO #letters VALUES ('D70')
INSERT INTO #letters VALUES ('D71')
INSERT INTO #letters VALUES ('D72')
INSERT INTO #letters VALUES ('D73')
INSERT INTO #letters VALUES ('D74')
INSERT INTO #letters VALUES ('D75')
INSERT INTO #letters VALUES ('D76')
INSERT INTO #letters VALUES ('D77')
INSERT INTO #letters VALUES ('D78')
INSERT INTO #letters VALUES ('D79')
INSERT INTO #letters VALUES ('D80')
INSERT INTO #letters VALUES ('D81')
INSERT INTO #letters VALUES ('D82')
INSERT INTO #letters VALUES ('D83')
INSERT INTO #letters VALUES ('D84')
INSERT INTO #letters VALUES ('D85')
INSERT INTO #letters VALUES ('D86')
INSERT INTO #letters VALUES ('D87')
INSERT INTO #letters VALUES ('D88')
INSERT INTO #letters VALUES ('D89')
INSERT INTO #letters VALUES ('D90')
INSERT INTO #letters VALUES ('D91')
INSERT INTO #letters VALUES ('D92')
INSERT INTO #letters VALUES ('D93')
INSERT INTO #letters VALUES ('D94')
INSERT INTO #letters VALUES ('D95')
INSERT INTO #letters VALUES ('D96')
INSERT INTO #letters VALUES ('D97')
INSERT INTO #letters VALUES ('D98')
INSERT INTO #letters VALUES ('D99')

SELECT	ASCII(WelderId) + 
	ASCII(SUBSTRING(WelderId,2,1)) + 
	ASCII(SUBSTRING(WelderId,3,1)) AS 'WeldIdAscii'
FROM #letters
END