RE: || in 4gl
Sadagopan, Sathish wrote:
> Hi,
> Is it not possible to use the concatenation operator || in sql =
statements in
> 4GL ?
> TIA
> sathish
Sathish:
Yes you can, but only in PREPARE-d SQL statements. If that's a major =
hassle, the alternative is to join the columns programmatically, ie:
SELECT col1, col2 INTO var1, var2
FROM ...
LET some_var =3D var1, var2
Hope that helps
RET
+------------------------------------------+
| Richard Thomas |
| DBA - Marketing Information Systems |
| Optus IT |
| email: richard_thomas@yes.optus.com.au |
| Ph: +61 2 9342 7188 |
| "My opinions are my opinions" |
+------------------------------------------+