Thanks Massimo for ur reply
On Apr 26, 2:26 pm, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > You cannot. You can use a virtual field. > > On Apr 26, 5:12 am, Neveen Adel <nevo.a...@gmail.com> wrote: > > > Hello, > > > Is there a way to select concatenation of fields as : > > > select concat_ws( ' ', codes.prefix,codes.suffix,codes.name )as > > name from codes > > > How can do this by db().select()?? > > > Thanks in Advance