SELECT FISTNAME || " " || LASTNAME AS NAME FROM USERS

----- Original Message -----
From: "netsurfer_ro" <netsurfer_ro@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, January 03, 2005 8:06 AM
Subject: [firebird-support] how can i concatenate 2 columns inside a select?


>
>
> how can i concatenate 2 columns inside a select?
>
> in FoxPro i was able to do something like this:
> SELECT FISTNAME+" "+LASTNAME AS NAME FROM USERS
>
> the result was ONE COLUMN made from the concatenation of
> FirstName,LastName and a blank space
>
> How can i do such thing in FireBird ?
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>