How to write IsNullOrEmpty method similar to ISNULL in sql server

sql-server isnull isnullorempty
vishal picture vishal · Aug 19, 2015 · Viewed 10.9k times · Source

I want to have function in sql server similar to ISNULL() except it should check expression for null and empty also.

If first parameter is null or empty, returns second.

can someone help me?

Answer

Tim Schmelter picture Tim Schmelter · Aug 19, 2015

You can use NULLIF and ISNULL:

SELECT ISNULL(NULLIF(@parameter, ''), @parameter2)

Related questions

C# equivalent of the IsNull() function in SQL Server

In SQL Server you can use the IsNull() function to check if a value is null, and if it is, return another value. Now I am wondering if there is anything similar in C#. For example, I want to do …

Read More
SQL Server Check for IsNull and for Zero

I have the following: set @SomeVariable = @AnotherVariable/isnull(@VariableEqualToZero,1) - 1 If @VariableEqualToZero is null it substitutes the 1. I need it to substitute 1 if @VariableEqualToZero = 0 as well. How do I do this?

Read More
Is there a opposite function to ISNULL in sql server? To do Is not null?

I have this code in my select statement ISNULL(a.PolicySignedDateTime,aq.Amount) AS 'Signed Premium', But I want to see if "a.PolicySignedDateTime" is not null. Is there a easy function to do this which does not involve using …

Read More