concatinate two columns in query
Posted: Wed Aug 30, 2006 8:14 am
How is this done in MYSQL. I can't figure it out. In oracle it is this:
Select fname || lname as name from users
Any help would be greatly appreciated!
Select fname || lname as name from users
Any help would be greatly appreciated!