Hi,

I have a table called "Name". It has two colums "PersonName" and "Age".

I insert some data in it like that most of rows of "PersonName" has same first name buy different second name.

Now i want to print all the Person name with their age from database whose firstnames are same.

But problem is that both firstname and last name are in same colunm.

Can anybody tell me how i can do that.

And please don't suggest that make another column for last name.

Please help me......