>>>>>>How do you strip spaces out from a field value.
>>>>>>
>>>>>>alltrim(thisform.myfiled.value).. the value is 'modem'
>>>>>>
>>>>>>when I say..
>>>>>>
>>>>>>myvar = alltrim(thisform.myfiled.value)
>>>>>>
>>>>>>myvar is 'modem' but is has two more spaces in it.
>>>>>>
>>>>>>should have 5 spaces, but it has 7 spaces.
>>>>>>
>>>>>>what to do?
>>>>>
>>>>>Come on, ALLTRIM will always trim all heading and trailing spaces.
>>>>
>>>>my code is..
>>>>SELECT * FROM mytable;
>>>>WHERE UPPER(ALLTRIM(THISFORM.fld.VALUE)) $ table_fld
>>>>
>>>>this does not work..but it will work if I...
>>>>
>>>>WHERE upper('modem') $ table_fld.
>>>>
>>>>why?
>>>
>>>Try this:
>>>cString=UPPER(ALLTRIM(THISFORM.fld.VALUE))
>>>SELECT * FROM mytable;
>>>WHERE cString $ table_fld
>>
>>does not work..
>>
>>I asked about the spaces because when I check for the len(), it
>>shows up as 7. In my test program that does work, the len() shows
>>up as 5. The only difference is.. One of my values in the WHERE clause is
>>UPPER(ALLTRIM(THISFORM.fld.VALUE)) - does vfp50 have a bug?
>>
>>thanks
>
>Do ypu want to say that LEN(cString)=7? Test this line in code?

In my test program that works, my len() = 5. In the form that does not
work, the len()=7. that should be the same..???