SQL Conditional query for null or empty values

Question

we have a very old database table that is used for discount codes.

Right now we have columns called discountValue & discountPercent

When a user creates a voucher code, if it is a value amount the value is stored in the value column, and if it is a percentage value this value is stored in the percentage column.

We are using MSSQL 2012 now and have just realised about this problem as it makes the UI look quite awkward.

Is there a way within SQL for MSSQLServer to query the database and alias a column in the output that detects if one of the columns is empty, it will use store the value in 1 column we can use to output to the user ?

I imagine this is kind of like a conditional statement... but im not sure how to write such a thing in MSSQL ?

thanks in advance

plalx · Accepted Answer · 2013-11-09 02:26:56Z

2

You can use ISNULL or COALESCE.

SELECT ISNULL(column1, column2) AS some_column
FROM SomeTable

answered Nov 9, 2013 at 2:26

plalx

43.8k7 gold badges77 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

HABO Over a year ago

Good information about COALESCE and ISNULL is at MSDN Blogs [here](blogs.msdn.com/b/sqltips/archive/2008/06/26/… ).

Edper · Accepted Answer · 2013-11-09 02:26:17Z

1

Use COALESCE() function:

SELECT COALESCE(discountValue, discountPercent) as Discount
FROM Table

See Link here

answered Nov 9, 2013 at 2:26

Edper

9,3621 gold badge32 silver badges49 bronze badges

Collectives™ on Stack Overflow

SQL Conditional query for null or empty values

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related