SQL Query when text is used

Question

Hi,

I am trying to find a way around to text field to show in SQL query. I have used the below but unable to get the text field

Select ISNULL (MStockDes ,NComment ) Description from SorDetail
Where SalesOrder = '29292'

If I change the query to

Select ISNULL (NComment ,MStockDes ) Description from SorDetail
Where SalesOrder = '29292'

I get to see the text field but not the actual MStockDes.

Is there something I am missing to show the text if there is no description in the field?

Thanks,

Answer 1

ISNULL() returns the first non-NULL value ONLY. https://learn.microsoft.com/en-us/sql/t-sql/functions/isnull-transact-sql?view=sql-server-ver15

It sounds like what you are really wanting is CONCAT(). https://learn.microsoft.com/en-us/sql/t-sql/functions/concat-transact-sql?view=sql-server-ver15