check this
fiddle [
^]
select top 1 SUBSTRING(id, CHARINDEX('-',id)+1, DATALENGTH(id)), id
from Test order by 1 desc;
select max(SUBSTRING(id, CHARINDEX('-',id)+1, DATALENGTH(id)))
from Test;
If you need to build PO from integer column data then try with
select 'PO-' + CONVERT(varchar(10), id) from Test2
Sample[
^]