SQL Query when text is used

asked 2021-11-08T13:22:44.967+00:00
moses004 41 Reputation points

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,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,089 questions
No comments
{count} votes

0 additional answers

Sort by: Most helpful