SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE WorkingTable (Working NCHAR(10)); INSERT INTO WorkingTable VALUES ('1'), ('3'), ('257'); SELECT top 1000 Working, CASE WHEN Working LIKE '%1%' THEN 1 ELSE 0 END as Mon, CASE WHEN Working LIKE '%2%' THEN 1 ELSE 0 END as Tue, CASE WHEN Working LIKE '%3%' THEN 1 ELSE 0 END as Wed, CASE WHEN Working LIKE '%4%' THEN 1 ELSE 0 END as Thu, CASE WHEN Working LIKE '%5%' THEN 1 ELSE 0 END as Fri, CASE WHEN Working LIKE '%6%' THEN 1 ELSE 0 END as Sat, CASE WHEN Working LIKE '%7%' THEN 1 ELSE 0 END as Sun from WorkingTable;