ALTER PROCEDURE [dbo].[pr_OrderItem_history] (
@PipCode    varchar(50),
@BarCode    varchar(150),
@Status     Char(10)
)
AS
BEGIN
select 
PID.PO_ItemID,

static string UppercaseFirst(string s)
    {
        if (string.IsNullOrEmpty(s))
        {
            return string.Empty;
        }
        char[] a = s.ToCharArray();
        a[0] = char.ToUpper(a[0]);
        return new string(a);
    }