At 06:23 PM 04-01-02 +0900, you wrote:

>In sqlserver, the sql statement is success.
>
>'select name + '<' + age + '>' from vuser;
>
>But.. In interbase, It's failed...
>
>I want to use like that...
>
>How can i do???

sqlserver uses non-standard symbology for concatenating strings. Use the standard SQL concatenator || (double-pipe) and you will be fine. If age is not a character field, you will also need to cast it as varchar of a suitable length.

select name || '<' || age || '>' from vuser
select name || '<' || cast ( age as varchar(2) ) || '>' from vuser

regards,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________