Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. (((IIf(IsNull(Production!Product_Title) Or Production!Product_Title Like "Process*",
  2. "Not Started", "Started"))="Not Started") And ((Person.Type) Is Not Null))
  3.  
  4. (
  5. (
  6. Production.Product_Title IS NULL
  7. OR Production.Product_Title Like 'Process%'
  8. )
  9. AND Person.Type IS NOT NULL
  10. )
  11.  
  12. SELECT
  13. CASE WHEN
  14. Production.Product_Title IS NULL
  15. OR Production.Product_Title Like 'Process%'
  16. THEN 'Not Started'
  17. ELSE 'Started'
  18. END AS [ProductState]
  19. FROM YourTable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement