A coworker who works mainly in C# wanted to know if there's an IsNullOrEmpty function.
After a brief NO, i've given him this one.
So far it works great.
CREATE FUNCTION dbo.IsNullOrEmpty(@text NVARCHAR(4000))
RETURNS BIT
AS
BEGIN
IF ISNULL(@text, '') = ''
BEGIN
RETURN 1
END
RETURN 0
END
GO
DECLARE @text VARCHAR(100)
SELECT @text = 'gdrfash5'
SELECT dbo.IsNullOrEmpty(@text)
SELECT @text = ''
SELECT dbo.IsNullOrEmpty(@text)
SELECT @text = ' '
SELECT dbo.IsNullOrEmpty(@text)
SELECT @text = null
SELECT dbo.IsNullOrEmpty(@text)
