DBObj

My codes are as below; i just need to add few more lines into it stating that the return newcode = strcode.

i’m not sure on that part.

private string CheckCode(string Str)
{

string NewCode = string.Empty;
string strCode = “Select’littl’+RIGHT(‘000’+LTRIM(STR(MAX(Cast(SUBSTRING(code,6,4)as int))+ 1)),4)from horseMaster where code like ‘littl0%'”;
DataTable dtCode = DBObj.QueryDB(strCode).Tables[0];

return NewCode;