There can be more than 2 clientid seperated by coma.

Is there a workaround using while loop, to find the left or right ..??

yes! sorry my mistake .

but the final resultset also contain the data for client id 's:

1

4

11

44

apart from what was needed.Is there any way to get the exact resultset

The Clientid you took for the example worked fine. but if the clientid 1,4 ... are also present in the table. the resultset also contain the details of these...