<div>
You don't need a special function, just some string manipulation. &nbsp;You could do something like this.<br />
<br />
SELECT SUBSTRING(YourColumn, CHARINDEX('-', YourColumn) + 2, CHARINDEX('-', YourColumn, CHARINDEX('-', YourColumn) + 1) - CHARINDEX('-', YourColumn) - 2)<br />
<br />
Greg<br />
<br />

</div>


You don't need a special function, just some string manipulation.  You could do something like this.

SELECT SUBSTRING(YourColumn, CHARINDEX('-', YourColumn) + 2, CHARINDEX('-', YourColumn, CHARINDEX('-', YourColumn) + 1) - CHARINDEX('-', YourColumn) - 2)

Greg



<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
using Microsoft SQL Server 2005. I need a SQLfunction or statement to get part of a varchar. <br />
<br />
All the values will have 2 dashes '-' like this:<br />
<br />
AZ - District of Arizona - Phoenix<br />
CA - Central District of California - San Fernando Valley<br />
FL - Northern District of Florida - Tallahassee<br />
<br />
I need to get everything to the left of the second dash without the space before it. &nbsp;So I would need<br />
<br />
AZ - District of Arizona&lt;no space&gt;<br />
CA - Central District of California<br />
FL - Northern District of Florida<br />
<br />
<br />
somewhat new I have no idea any help please
</div>
</div>


Hi 

using Microsoft SQL Server 2005. I need a SQLfunction or statement to get part of a varchar. 

All the values will have 2 dashes '-' like this:

AZ - District of Arizona - Phoenix
CA - Central District of California - San Fernando Valley
FL - Northern District of Florida - Tallahassee

I need to get everything to the left of the second dash without the space before it.  So I would need

AZ - District of Arizona<no space>
CA - Central District of California
FL - Northern District of Florida


somewhat new I have no idea any help please

Need SQL function to get part of sring

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.