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