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
<span class="kwrd">RETURN</span> 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)