[web2py] select concatenation of fields

[Neveen Adel]

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