Q:

SQL LAST() Function

I have the following part of C# code
cmd = new SqlCommand("SELECT TOP 1 * FROM "+label7.Text+" ORDER BY searches DESC ", con);
var columnSize = cmd.ExecuteScalar();
int plithos = int.Parse(string.Format("{0}", columnSize));

Where con is my connection string. All i want to do is to put in plithos the last value of the column searches. The column searches has more than 17 records but for some reason plithos gets the ninth record of the column searches with that part of code is not suppose to take value of the last record ? The application i am building is a form application in Visual Studio. Please help me this is so frustrating  
Here is the column searches
Searches| 
    1
    2
    3
    4
    5
    6
    7
    8
    9-> value of plithos
    .
    .
    .
    19

A:

The answer thanks to PaulAbbott is the following command :
cmd = new SqlCommand(SELECT TOP 1 searches FROM "+label7.Text+" ORDER BY cast(searches as int) DESC

