Re: [dba-dev] SRB missing text FUNTIONS

2010-05-10 Thread Ocke Janssen
Hi Fernand, Fernand Vanrie wrote: Ocke Janssen wrote: Jocke, Thanks for the Reply, but no i Tried al this stuff before LEFT([textfieldname] ; 3 ) is working and returns the first 3 chararters of the field text must been included in double quotes "text" > works fields must been include in

Re: [dba-dev] SRB missing text FUNTIONS

2010-05-10 Thread Fernand Vanrie
Ocke Janssen wrote: Jocke, Thanks for the Reply, but no i Tried al this stuff before LEFT([textfieldname] ; 3 ) is working and returns the first 3 chararters of the field text must been included in double quotes "text" > works fields must been include in scuare brackets [Textfiledname] [Te

Re: [dba-dev] SRB missing text FUNTIONS

2010-05-10 Thread Ocke Janssen
Hi Fernand, Fernand Vanrie wrote: Maybe a stupid question or i looked just over it : but why is a very usefull text Function as CONCAT or CONCATENATE not available in the Sun Report Builder ? I don't remember exactly but shouldn't it be possible to just write 'column1' + ' ' + 'column2'