>>>>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
You HAVE checked the length of the field in the file itself I trust. I'm betting that the field length in the file in the DE of the form is 7 char long. As far as the ALLTRIM, there have been times when (for whatEVER reason) it refused to work properly in a SQL. Yeah, it's a pain, but hey....
What does table_fld look like?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place