Skip to content
Advertisement

Split Characters in a cell to individual columns [closed]

I have a dataset where a column contains 1 and 0 in a single cell which reference security authorities in a software program. I need to split these out into individual columns as these denote (0) No Access and (1) Access

Example:

Expected Outcome

Appreciate any help on this sql statement to make this happen

Thanks Paul

Advertisement

Answer

With the assumptions proposed by @Stu, a simplified version would be

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement