joelucas

Thank you very much, this is a very smart solution!

Thanks for all your guys response.

Here is the scenario how this query come from

I have an table tbl_primary which has column rowid,field1, field2, where rowid is Primary Key

The users can...

Hi, bbychkov

Thanks your response and your query did works. But since this is a ad-hoc query, In advance I did not know th possible value

for caption column. Hopfully...