Advertisement
Guest User

Untitled

a guest
Oct 21st, 2014
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT orderid,
  2. orderdate,
  3. case
  4. when shipdate IS NULL THEN shipdate = 'Not Shipped'
  5. ELSE 'shipped'
  6. END shipstatus
  7. FROM orders
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement