select top 50

[thomasa]

I have a sql string that gets the top 50 items in a search. Shomthing like: string SQL = "SELECT TOP 50 U.strName " + "FROM tbUser U " + "WHERE U.strName LIKE '%om%' " DataManager dm = new DataManager(); DataTable table = dm.GetDataTable(SQL); but I also want to find exact how many there are. My result would be something like "There are 387 names with the searchstring 'om' here are the top 50: ...." Can this be done with the "SELECT TOP" statement. I'm using MS SQL Server 2000. Thanks Thomas -- modified at 13:15 Friday 20th January, 2006

[Mike Ellison]

You can always run a second query - "SELECT Count(*) From tbUser WHERE ... " - in your search procedure, and return that count with the results.

[Muhammad Javed Khan]

Try this "SELECT TOP 50 U.strName , (Select Count(*) From tbUser) as TotalRecords " + "FROM tbUser U " + "WHERE U.strName LIKE '%om%' " Regards