How to convert date values to text and Concatenate in SQL Exp Builder

[DyerQ]

I need to create a field to use as link to an outside database in the SQL expression Builder in Crystal Rep XI.

I am able to get Month()+ Year() from a date field but I need to

Convert Month() to string + Convert Year() to string + "String"

Then I would have something like 122009AB as my value to use for
my query connection to the outside table.

I don't see the functions to do this in the expression builder.
Can this be accomplished in the expression builder ?
Thanks in advance.

 

[lbass]

This really depends upon the functions available to your particular datasource, but you could try something like this:

{fn convert({fn month(`table`.`date`)},sql_varchar)}&
{fn convert({fn year(`table`.`date`)},sql_varchar)}&`table`.`string`

Or, if you are hardcoding the string: & 'AB'

-LB