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