Re: String concatenation in 4gl

Do you want to concatenate a string in 4Gl or issue a select? For the first case the syntax is LET c = a,b For the second, assign your select to a char-variable, prepare, execute and fetch it. Sincerely, Roland Peter Tashkoff wrote: > > It's a day for questions... > In sql you can do this > > select a || b as c, sum(d) from e group by 1 > > In our legacy system we need to group by >16 levels > and so want to do the above but can't figure out how > to do it in 4gl. It's possible that we could code this > in an SP as a workaround. > Any advice much appreciated. > > Thanks in advance > -- > -- > Peter Tashkoff > NZ Kiwifruit Project Consultant/DBA > Marketing Board. Standard Disclaimers apply > This posting may not be used by any commercial > organisation to vilify another.