Environment versions
Network:
Windows 2000 Server
>What I'm hoping I can come up with is something like
>
>Select codedesc as Name, memofield as Alias
> from codetable c
>where c.coddtype = "somegroup"
>
>and have 'Alias' be a character field, not a memo field
>
In VFP 9, use the CAST() function:
SELECT codedesc AS Name, CAST(memofield AS C(100)) AS Alias ...
Tamar
Previous
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