/*************************************************************************************************
		Copyright © 2001 Narayana Vyas Kondreddi. All rights reserved.
                                          
Purpose:	To split a column into two using a SELECT statement based on a condition

Written by:	Narayana Vyas Kondreddi
		http://vyaskn.tripod.com

Tested on: 	SQL Server 7.0 and SQL Server 2000

Date modified:	March-22-2001 6:00 PM

Email: 		vyaskn@hotmail.com
*************************************************************************************************/

--Consider the following table

CREATE TABLE tblsplit
(
Category char,
U_Name varchar(25)
)

GO

--Insert the following data into the table

INSERT INTO tblsplit (Category, U_Name) VALUES ('H', 'Narayana Vyas Kondreddi')
INSERT INTO tblsplit (Category, U_Name) VALUES ('H', 'Vijaya Madhuri G')
INSERT INTO tblsplit (Category, U_Name) VALUES ('L', 'Pamarthy Pradeep Kumar')
INSERT INTO tblsplit (Category, U_Name) VALUES ('L', 'Pamarthy Harinath Baba')

GO

-- Here's the query
SELECT 
CASE WHEN Category = 'H' THEN Category ELSE '' END as 'Higher income group', 
CASE WHEN Category = 'L' THEN Category ELSE '' END as 'Lower income group',
U_Name 
FROM tblsplit