SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Model_Master] AS
SELECT [No_] AS [Model No_]
     , [Make Code]
     , [Description]
     , CASE
           WHEN [Gen_ Prod_ Posting Group] IN ('', 'FEHLER') THEN [Vehicle Category Code]
           WHEN [Gen_ Prod_ Posting Group] LIKE '%_FZG_%' THEN [Vehicle Category Code]
           ELSE [Gen_ Prod_ Posting Group] END AS [Model_Group_Code]

FROM [GC_TRANSIT_ARI].[import].[Model_Master]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO