>>>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
Edward Pikman
Independent Consultant