HI. I have to write a case statement ,that is for example in a table there are three feilds ID,First_nm,Last_nm. From this table I have to write a query based on if the id ends with a zero then that Id belongs to Employee. If it ends with anything else than zero then it belongs to his family member. below is the example id 1000 then employeename, id 1001 then wife or son name, similarly id 2000 another employee name , 2001 his sons name.so finally the whole family( fathername/employeename and son name in one row. Then fathername and daughter name in another row),should come in one row, and the columns that get displayed are firstname, lastname,familymember firstname , lastname. Please Help.