Thanks Serg.
select Cast(right(rtrim(pa_page),3) AS int) AS 'value',
* from deppage
errors on :
Syntax error converting the varchar value 'O-8' to a column of data type int.
I have lots of Embedded #'s in this column. XXX-NNNX or XX-NN or XXX-NNX
Maybe a union to pull from the 3 NNN #'s as well as the primary 2 NN #'s?
I'm still getting Whacked by the occassional last Letter?
__Stephen
>You can use CAST() or CONVERT() functions.
>
>>I have a column VarChar(15) that I need to find the highest value in. It's a part # and I need to add a 1 to the existing part #.
>>
>>ALL-15, FLR-142A, MAK-97W, ZR-5
>>
>>I could cheat in VFP with a VAL(). How can I pull this out in a Select Statment?
>>
>>TIA
>>
>>__Stephen