ATC(" ",Desc,4)
Also, it's not a good way to use 'Desc' as field name.

>I have a description field that I am trying to retrieve information from to use in new fields. I thought ATC would work but it keeps returning 0 as the value. Using the below example, I expect ATC(Desc, " ", 4) to return 21 (the position of the 4th occurence of a space). ln_position would have a value of 6. lc_invno would have a value of 123456. Which is what I want.
>
>However, ATC(Desc, " ", 4) is always returning 0, so ln_position always has a value of -15 and in the below example returns 123456 0100. What am I doing wrong? BTW, V# will always be 6 positions, but IV# can be 1 to 10 positions.
>
>TIA for your help! :)
>
>Desc = V# ABC001 IV# 123456 0100
>
>ln_position = (ATC(Desc, " ", 4) - 15)
>
>IF ln_position < 0
> lc_invno = ALLTRIM(SUBSTR(Desc, 15, 21))
>ELSE
> lc_invno = SUBSTR(Desc, 15, ln_position)
>ENDIF