Good day to you all.

Does anyone know how to concatenate serial numbers with a text in SQL Server?.
I want some thing like this

Select Max(ID) from TableName;
lets say the query returns 6789.
I want the result to concatenate with REC

So that i will have REC6789 as my final result, while the next one will have to be REC6790. I want to be able to achieve this in ASP.NET C#

y dont u do d concatenation in d c# code den insert d new value into database?

Why don't you declare a variable in your code and then concatenate it with the returned value

Select 'REC' + Cast(Max(ID) as varchar(4)) SerialNum from TableName

it's so easy

but you must be careful when doing it PM me we tell u