How do I concatenate to columns?

        ResultsetFields fields = new ResultsetFields(4);
        fields.DefineField(StreetFields.UniqueId, 0, "UniqueId");
        fields.DefineField(StreetFields.Street, 1, "Street");
        fields.DefineField(StreetFields.Suburb, 2, "Suburb");
        fields.DefineField(StreetFields.Town, 3, "Town");

I just want to combine Street and Suburb into one field.

Thanks, John

You can use expressions. See the "Expressions in select lists" code snippets.

daelmo wrote:

You can use expressions. See the "Expressions in select lists" code snippets.

Thanks got it to work

        ResultsetFields fields = new ResultsetFields(4);
        fields.DefineField(StreetFields.UniqueId, 0, "UniqueId");
        fields.DefineField(new EntityField("Street", (StreetFields.Street + " - " + StreetFields.Suburb)), 1);
        fields.DefineField(StreetFields.Suburb, 2, "Suburb");
        fields.DefineField(StreetFields.Town, 3, "Town");