netsurfer_ro wrote:

> 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

SELECT FIRSTNAME || ' ' || LASTNAME AS NAME FROM USERS

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services