<div>
<pre><code id="code-20-42824519-1">SELECT LEFT([Name],3) AS Doc</code></pre>
</div>


<div>
Sorry, The document can be of any length , For example there can be DoooooocVol123
</div>


Sorry, The document can be of any length , For example there can be DoooooocVol123

<div>
So, what is the criteria for the extract? Everything up until <b>Vol</b>?<br />
So, in the example above, you would want <b>Doooooc</b>?
</div>


So, what is the criteria for the extract? Everything up until Vol?
So, in the example above, you would want Doooooc?

<div>
That is right- extract &nbsp;Everything up until Vol
</div>


That is right- extract  Everything up until Vol

<div>
Of course you need to use [TB-Docs] in above query ;-)
</div>


Of course you need to use [TB-Docs] in above query ;-)

<div>
<div class="content wysiwyg-content">
Hi &nbsp;I have &nbsp;a table &nbsp;TB-Docs in Sql Server 2016 &nbsp;with a filed Name ( and other fields) &nbsp;. There are some names ending &nbsp;like Doc1VOL01 , Doc1VOL11 &nbsp;, Doc1Vol123 <br />
<br />
Eg.<br />
&nbsp; &nbsp; Doc1Vol01<br />
&nbsp; &nbsp; Doc1Vol11 &nbsp; &nbsp;<br />
&nbsp; &nbsp; Doc3Vol123<br />
&nbsp;<br />
&nbsp; &nbsp;I need result with Volume rows and the substring of the &nbsp;Document name &nbsp;( All I need to know is how to get the substring like Doc1 from a string of Doc1Vol01)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Doc <br />
&nbsp; &nbsp; &nbsp; &nbsp; ----- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ----<br />
&nbsp; &nbsp; &nbsp;Doc1Vol01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Doc1<br />
&nbsp; &nbsp; Doc1Vol11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Doc1<br />
&nbsp; &nbsp; Doc3Vol123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Doc3<br />
<br />
<br />
Edit : Name can be of any length , for example, there can be a Doooooc1Vol01
</div>
</div>


Hi  I have  a table  TB-Docs in Sql Server 2016  with a filed Name ( and other fields)  . There are some names ending  like Doc1VOL01 , Doc1VOL11  , Doc1Vol123 

Eg.
    Doc1Vol01
    Doc1Vol11    
    Doc3Vol123
 
   I need result with Volume rows and the substring of the  Document name  ( All I need to know is how to get the substring like Doc1 from a string of Doc1Vol01)
        Name                 Doc 
        -----                     ----
     Doc1Vol01           Doc1
    Doc1Vol11            Doc1
    Doc3Vol123          Doc3


Edit : Name can be of any length , for example, there can be a Doooooc1Vol01

Sql Server query to get substring

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.