set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create FUNCTION [dbo].[FunGoodLastDate](@Code int) RETURNS char(8) AS BEGIN Declare @R char(8) SELECT TOP (1) @R= InvoiceDate FROM VWInvoiceDetailComplete WHERE (GoodSysCode = @code) AND (Amani = 1) AND (Type = 2) OR (GoodSysCode = @code) AND (NOT (FK_DocsysCode IS NULL)) AND (Type = 2) ORDER BY SysCode DESC RETURN @R END