Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Production: 1 = (yes), 0 = (no)
- Office: 1 = (yes), 0 = (no)
- Storage: 1 = (yes), 0 = (no)
- CASE WHEN "Production" = 1 THEN 'P' ELSE '' END
- P/S
- O/S
- P/O
- P/O/S
- regexp_replace( if("production"=1,'P/','') || if("office"=1,'O/','') || if("storage"=1,'S/',''),'/$','')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement