WeldView

create view "WeldVW" ( "WeldId", "WeldTypeId", "WeldTypeName", "Abbreviation", "ParentId", "WelderId", "WelderIdAscii", "WeldProcedureId", "ProcedureName", "SpoolId", "SpoolRevisionNumber", "Size", "Comment", "WeldDate", "WeldTag", "DrawingId", "DrawingRevisionNumber", "WeldStatus", "StatusName") 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", c1."SpoolRevisionNumber", c1."Size", c1."Comment", c1."WeldDate", c1."WeldTag", c1."DrawingId", c1."DrawingRevisionNumber", dbo.GetCurrentWeldStatus(c1."WeldId"), dbo.GetCurrentWeldStatusName(c1."WeldId")  	from "Weld" c1, "WeldType" c2, "WeldProcedure" c3  	where c1."WeldTypeId" = c2."WeldTypeId" and		c1."WeldProcedureId" = c3."WeldProcedureId"  with check option