Is it possible to do an sql search like the following:-

Select name from table where name = “James”

And then instead of returning that record returning the row in the table that that record is on?

If someone could let me know how to do this i would really appreciate it.

I want to do this because i have a flexigrid that shows the data from a table but none of the data in the table corresponds to the row it sits in. So i need to find where the searched data is in the table so i can then highlight that record on the flexigrid.