You've seen other responses describing how it works. I've actually used it a couple of times in SQL statements rather than PADR() and TRIM() to ensure that the first returned record is wide enough not to cause problems for the remaining records. If memory serves, this was primarily when converting Last Name, First Name, MI fields into one Full Name field.


>I am converting some programs from FoxPro 2.6a for Windows.
>
>Could someone explain to me what the following minus sign (-) is doing? I can't find this in VFP 6.0 Help. The man whom I am to replace says that it hits the end of the data in the Loading.Desc field, rather than the end fo the filed, which would include the spaces after the data. Why is this not listed in the Help File, or was it in FPW 2.6a?
>
>

>	IF UPPER(LOADING.adjust) = 'X'
>		REPLACE LOADING.DESC WITH ;
>			LOADING.DESC -'['-STR(LOADING.net)-'lbs]'
>		REPLACE LOADING.net WITH 0
>	ENDIF
>

>
>I would have done the following:
>

>	IF UPPER(LOADING.adjust) = 'X'
>		REPLACE LOADING.DESC WITH ;
>			ALLTRIM(LOADING.DESC) + '['-STR(LOADING.net)-'lbs]'
>		REPLACE LOADING.net WITH 0
>	ENDIF
>