I need to pull the last value from the field.. How do i do this? All three numbers are in the same field. The data type is nvarchar.. I want to pull out the 1799.. NO $ just the 1799.. Some of the fields could have $800 and I want only 800.. I know the code below works for the first value(599) but how do I extract the last?