General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks, Sergey, that did it.
>>Hi All -- Is there a way to get the distinct values of a memo field into a text field in a different table using ALLTRIM() that doesn't truncate all of the values to the length of the first record's value? I can do it by indexing on the length of the field, copying the data to a table while the index is in place and then using ALLTRIM(), but it's cumbersom. I know VFP9 just does it, but I'm constrained to work with VFP70.
>>
>
>You can use PADR(ALLTRIM(), 254).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only