Something

USE WMS
GO

CREATE VIEW WelderVW
AS
	SELECT	E.EmployeeId, E.LastName, E.FirstName
	FROM	Employee E
	WHERE	E.EmployeePositionId = ( SELECT EP.EmployeePositionId
									 FROM	EmployeePosition EP
									 WHERE	LOWER(EP.PositionName) = LOWER('Welder'))