(y)
الداله تعمل جيدا وهذا تعديل فى أسماء الحقول لتعمل مع ال North Wind Database
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER FUNCTION [dbo].[fncTT] (@s as CHAR)
RETURNS CHAR(20)
AS BEGIN DECLARE @ttt CHAR(20)
IF isnumeric(@s)= 1 AND PATINDEX('%[A-Z]%',@s)=0
SELECT @ttt = 'All Number'
ELSE
SELECT @ttt = 'NOT All Number'
RETURN @ttt
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ولاستدعاء الداله
SELECT CategoryID,CategoryName, dbo.fncTT(CategoryName) AS checkmytext
FROM dbo.Categories
WHERE (dbo.fncTT(CategoryName) = 'All Number')
