>>>>>>>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..???

Try STRTRAN(UPPER(ALLTRIM(THISFORM.fld.VALUE)). Your field may have 2 spaces embedded.
HTH
Sorin