How to get the current URL from ASP.NET code behind

string url = HttpContext.Current.Request.Url.AbsoluteUri;

http://thehost.com/dir/Default.aspx

string path = HttpContext.Current.Request.Url.AbsolutePath;

/dir/Default.aspx

string host = HttpContext.Current.Request.Url.Host;

thehost.com

sql server code for find name start with a character WITHOUT using like

Select * from TableName where Left(ColumnName,1) in ('A')