Thanks Massimo for ur reply
On Apr 26, 2:26 pm, Massimo Di Pierro <[email protected]> wrote: > You cannot. You can use a virtual field. > > On Apr 26, 5:12 am, Neveen Adel <[email protected]> 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

