how can i create a sql to split data from a single column into 2 columns as below col 1 Y Y N N into Col A Col B Y N Y N Thanks for your help. Anan
Forum Rules