<div>
<div class="content wysiwyg-content">
I have a name field, some have first name, middle initial, last name. &nbsp;Others are just first name, last name. &nbsp;I want to create a new field with the last name only. &nbsp;There's always a space before the last name.<br />
<br />
Can someone tell me the statement I need to split this field?
</div>
</div>


I have a name field, some have first name, middle initial, last name.  Others are just first name, last name.  I want to create a new field with the last name only.  There's always a space before the last name.

Can someone tell me the statement I need to split this field?

Pull last name from full name field in SSRS

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

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.