| Subject | how can i concatenate 2 columns inside a select? |
|---|---|
| Author | netsurfer_ro |
| Post date | 2005-01-03T14:06:39Z |
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 ?
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 ?