Something

create view "WeldVW" ( "WeldId", "WeldTypeId", "WeldTypeName", "Abbreviation", "ParentId", "WelderId", "WelderIdAscii", "WeldProcedureId", "ProcedureName", "SpoolId", "SpoolRevisionNumber", "SpoolRevisionDate", "Size", "Comment", "WeldDate", "WeldTag", "DrawingId", "DrawingRevisionNumber", "WeldStatus", "StatusName", "ParentControlNumber", "SpoolReferenceNumber", "SpoolNo") as 	select c1."WeldId", c1."WeldTypeId", c2."WeldTypeName", c2."Abbreviation", c1."ParentId", c1."WelderId", case	when len( c1."WelderId" ) = 2 then ascii ( c1."WelderId" ) * 10000 + ascii ( substring(c1."WelderId", 2, 1) )	when len( c1."WelderId" ) = 3 then ascii ( c1."WelderId" ) * 10000 + ascii ( substring(c1."WelderId", 2, 1) ) * 100 + ascii ( substring(c1."WelderId", 3, 1) )end, c1."WeldProcedureId", c3."ProcedureName", c1."SpoolId", (SELECT TOP 1 SpoolRevisionNumber FROM SpoolRevision WHERE SpoolId = c1.SpoolId ORDER BY Date DESC), (SELECT TOP 1 Date FROM SpoolRevision WHERE SpoolId = c1.SpoolId ORDER BY Date DESC), c1."Size", c1."Comment", c1."WeldDate", c1."WeldTag", c1."DrawingId", c1."DrawingRevisionNumber", dbo.GetCurrentWeldStatus(c1."WeldId"), dbo.GetCurrentWeldStatusName(c1."WeldId"), (SELECT ControlNumber FROM SpoolRevision SR, Spool S WHERE c1.SpoolId = SR.SpoolId AND SR.SpoolId = S.SpoolId), (cast( (SELECT InternalDrawingNumber         FROM Drawing D         WHERE c4.DrawingId = D.DrawingId) AS varchar) + '-' + c4.SpoolNo) , c4."SpoolNo"  	from "Weld" c1, "WeldType" c2, "WeldProcedure" c3, "Spool" c4  	where c1."WeldTypeId" = c2."WeldTypeId" and		c1."WeldProcedureId" = c3."WeldProcedureId"  with check option