Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (((IIf(IsNull(Production!Product_Title) Or Production!Product_Title Like "Process*",
- "Not Started", "Started"))="Not Started") And ((Person.Type) Is Not Null))
- (
- (
- Production.Product_Title IS NULL
- OR Production.Product_Title Like 'Process%'
- )
- AND Person.Type IS NOT NULL
- )
- SELECT
- CASE WHEN
- Production.Product_Title IS NULL
- OR Production.Product_Title Like 'Process%'
- THEN 'Not Started'
- ELSE 'Started'
- END AS [ProductState]
- FROM YourTable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement