<div>
If it's always at the beginning you could do a left, like:<br />
<br />
SELECT LEFT(myColumn,3) <br />
<br />
If it can be anywhere, something like this can help: <br />
<br />
SELECT SUBSTRING(yourColumnName,C<wbr />HARINDEX('<wbr />Ram',yourC<wbr />olumnName)<wbr />,3)<br />
<br />
If there are values that don't contain your text, you're going to have to handle them with a case statement.<br />
<br />
Hope it helps.
</div>


If it's always at the beginning you could do a left, like:

SELECT LEFT(myColumn,3)

If it can be anywhere, something like this can help:

SELECT SUBSTRING(yourColumnName,CHARINDEX('Ram',yourColumnName),3)

If there are values that don't contain your text, you're going to have to handle them with a case statement.

Hope it helps.

<div>
Hi<br />
<br />
That column has several data.<br />
<br />
Ram, Rishi, Tapas<br />
Stephen,Greek,John<br />
Pathan, Doni, Sachin.<br />
<br />
<br />
I want to display only the first value like<br />
<br />
Ram<br />
Stephen<br />
Pathan
</div>


Hi

That column has several data.

Ram, Rishi, Tapas
Stephen,Greek,John
Pathan, Doni, Sachin.


I want to display only the first value like

Ram
Stephen
Pathan

<div>
That's a bit different from the OP, but this should help:<br />
<br />
SUBSTRING(yourColumnName,1<wbr />,CHARINDEX<wbr />(',',yourC<wbr />olumnName)<wbr />-1)
</div>


That's a bit different from the OP, but this should help:

SUBSTRING(yourColumnName,1,CHARINDEX(',',yourColumnName)-1)

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a column which has &nbsp; &nbsp;'Ram, Rishi, Tapas'.<br />
<br />
I want to display only Ram. &nbsp;How to trim after ram .
</div>
</div>


Hi

I have a column which has    'Ram, Rishi, Tapas'.

I want to display only Ram.  How to trim after ram .

Trim in T-sql

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.