zachvaldez

<div>
not exactly <br />
format field to display value before the space. 129
</div>


not exactly
format field to display value before the space. 129

<div>
btw the answer is correct upon testing
</div>


<div>
<blockquote>format field to display value before the space </blockquote>You could add a CAST or CONVERT function for the two columns returned if you need them in a specific data type/format as I left them "as is" - char type - because there was no specific details about the data type.
</div>


> format field to display value before the space

You could add a CAST or CONVERT function for the two columns returned if you need them in a specific data type/format as I left them "as is" - char type - because there was no specific details about the data type.

<div>
<div class="content wysiwyg-content">
I want to parse in sql from a particular column<br />
Ref#<br />
129 009<br />
<br />
1.want to parse value before the space <br />
2. get last 2 digits from the right.<br />
<br />
both values will be in 2 separate columns/field
</div>
</div>


I want to parse in sql from a particular column
Ref#
129 009

1.want to parse value before the space 
2. get last 2 digits from the right.

both values will be in 2 separate columns/field

parsing in SQL

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.