I've always use it this way, but also always wondered that should be another way to do it.
If I want to do a simple

select *

It is a pain to type each column that comes as a memo when you have some 20+ of them.


>If memfield length is 254 or less

>Select codedesc as Name, PADR(memofield,254) as Alias
>from codetable c
>where c.coddtype = "somegroup"
>

>
>