Hi All.

I have a little problem with defining views in Allbase you may be able to
help me with. I have two tables which are linked by a concatenated key. I
want to do a SELECT similar to the example below, but the key items are
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);

TIA.
Mark Wilkinson
[log in to unmask]