I have the following values in my AnimalTag table under the column AnimalTagNumber.
In LINQ (preferably VB but C# if that's all I can get), how can I select the Max (although it is not numeric) where the first character is "D"?
I.e. for the above I'm wanting to return D00003.
Thanks for any assistance,Ron
You can use the following LINQ query statement, I have tested it in SQL server 2005, it works well.
var max_Query = (from tab1 in mydb.AnimalTag select tab1.AnimalTagNumber).Max();
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?