Query more tables together

Hi all,
I have a lot of tables in a database.I need top 1 record of all tables that table name ands with 'en' and i want to query this tables from sys.tables system table
Select name from sys.tables where name like '%en'
with this query i can list all the table names i need and how can i query the top 1 records from these tables.?
thanx in advanced

use cursor like below....declare
@name varchar(200),@cmd nvarchar(max)declare c1 cursor for
select
name from sysobjects where xtype = 'u'open
c1fetch
next from c1 into @namewhile
@@FETCH_STATUS = 0beginprint
'tablename is ' + @nameset
@cmd = 'select top 1 * from ' + @nameprint
@cmdexec
sp_executesql @cmdprint
'======================================================='fetch
next from c1 into @nameend
close
c1deallocate
c1
it have all the required details which you want to see. But you can delete any print which you not want to see.

bit modification....
i used query as
select name from sysobjects where xtype = 'u'
you can use your select statement but make sure you selecting only one value because thats what we passing into cursor.
Hope you understand what i mean

Using cursor is the worst way and i do not prefer using Cursor . Is there way way to achieve this?

what do you mean by worst way? Have you analyzed your query plan after running this cursor? Or is it just what you read in book?

i have not looked at query plan yet. i had used cursor before and i saw it has a bad performance so i did not no prefer this way.i can believe we can make everything without using cursors. we can chose another way instead of cursor can't it?

if you so afraid of curor
then you will getting the query which will be running with cursor by print @cmd
you can take help of this print and run all those syntax in new window