C#

SELECT     MAX(CAST(SUBSTRING(ColumnName, 0, CHARINDEX('/', ColumnName)) AS Integer)) AS ExpressionName
FROM         TableName

UPDATE YourTable
   SET YourField = '0'+YourField
 WHERE LENGTH(YourField) = 4;

zead wrote:

I use "select last_insertd_row from last_insrted_rows where table_nam=:t_name"

public class MyListView : ListView
{
    public event EventHandler Scrolled;

    private int WM_VSCROLL = 0x115;
    protected override void WndProc(ref Message m)
    {
        //msg=0x115 (WM_VSCROLL)
        if (m.Msg == WM_VSCROLL)
        {
            OnScrolled();
        }
        Debug.WriteLine(m);
        base.WndProc(ref m);
    }

    private void OnScrolled()
    {
        EventHandler localEvent = Scrolled;
        if (localEvent != null)
        {
            localEvent(this, EventArgs.Empty);
        }
    }
}

enum test1 : int { Hello, There } // works<br />
enum test2 : System.Int32 { Hello, There } // CLR types are not allowed

Sandeep Kalra wrote:

Now the challenge is where to store the Private Key so that i can retrive that key later to decrpyt the data and show to the user.