Hello comunity

First thanks for all of you for your replies.

I try this:

select substring('5695 - 0 | 7050-127 MONTEMOR O NOVO ',

charindex('|','5695 - 0 | 7050-127 MONTEMOR O NOVO ')+1 ,

len('5695 - 0 | 7050-127 MONTEMOR O NOVO ')) as [Last Name]

and sql query return the desire value:

7050-127 MONTEMOR O NOVO

Note: the value '5695 - 0 | 7050-127 MONTEMOR O NOVO ' is the content of my table field FT.DESCAR.

Best regards

Luis Santos