Mark Wilkinson wrote:
> alphanumeric and you can't use the '+' operator on alphanum fields...
>
> select a.theatre_nr, b.city_name from
> ifds02.theatre_sv a left join
> ifds02.cityv b on
> b.concat_key = 'C' + substring(cast(a.city_nr+10000000,char(8)),2,7);
the string concatatenation operator is '||' so try
b.concat_key = 'C' || substring(cast(a.city_nr+10000000,char(8)),2,7)
Regards
Michael