<div>
select right(fieldname, 2) from ...
</div>


<div>
so that would take the state out and into its own field?<br />
<br />
ex. &nbsp;'SOMEWHERE &nbsp; &nbsp; &nbsp; ST'<br />
<br />
needs to be 'SOMEWHERE' &nbsp; &nbsp; 'ST'
</div>


so that would take the state out and into its own field?

ex.  'SOMEWHERE       ST'

needs to be 'SOMEWHERE'     'ST'

<div>
<div class="content wysiwyg-content">
So the city and state is in one field in the DB2<br />
what would be the sybtex in SQL 2008 R2 to start on the far right<br />
go back two positions (the State in two positions)<br />
and create that as its own field?
</div>
</div>


So the city and state is in one field in the DB2
what would be the sybtex in SQL 2008 R2 to start on the far right
go back two positions (the State in two positions)
and create that as its own field?

create a Field for City and State that is in one field in DB2

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.