"Rikin Parekh" <rikin08@xxxxxxxxx> wrote in message news:FAD9D02D-2ADD-4A31-B118-81D56183ED4A@xxxxxxxxx... This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax errors in question table. Can someone please guide or help? Thanks, Rikin it looks like it will do what you want. I don't know why you are asking instead of trying it out. :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php