Hi,

Finally I got the Answer,

Select * from Employeeparent ep Join EmployeeChild ec On ep.Id = SUBSTRING(convert(Varchar(10),ec.id),1,Len(ep.id))

Thanks,

tony