To Pick up only left content of the word 
 
DECLARE @desc varchar(100)
SET @desc='EXCHANGEUNIT P1i / SILVERBLACK/ CYRILLIC'
SET @subdesc=RTRIM(LEFT(@desc, CHARINDEX('/', @desc) - 1))

SELECT REVERSE( LEFT( REVERSE(@subdesc), CHARINDEX(' ', REVERSE(@subdesc))-1 ) )

Comments

Post a Comment

Popular posts from this blog

Export gridview into excel pdf csv   http://www.aspsnippets.com/ Articles/Print-functionality- in-ASP.Net- GridView -control. aspx  http://www.aspsnippets.com/ Articles/Export- GridView -To- Word-Excel-PDF-CSV-Formats-in- ASP.Net.aspx
Read more
How to insert multiple rows from c# table to sql database table:- Frontend:   <asp:Button ID="Button2" runat="server" Text="Create Table"             onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server">         </asp:GridView> Backend C#:  protected void Button2_Click(object sender, EventArgs e)     {         //         // Here we create a DataTable with four columns.         //                 DataTable temptable = new DataTable();         temptable.Columns.Add("ProductID", typeof(string));         temptable.Columns.Add("RelatedProductID", typeof(string));       ...
Read more