Skip to Content
0
Former Member
Jun 22, 2010 at 01:11 AM

DocStatus to display as Cancelled or Closed in query

197 Views

Hi Experts,

How do I distinguish between Cancelled and Closed Documents in the following query:

 SELECT T0.[DocNum], T0.[DocStatus] FROM ORDR T0 

It brings back only a C.

Any help will be apprecaited.

Marli