I need a SELECT statement that returns the value of 3 columns together as 1 column (alias is fine)?

Question

col1, col2, col3 being returned all together as one collection of one name.

Example:
table
Col1 col2 col3
john smith jr
sally smith sr

result
ColAlias
john
sally
smith
smith
jr
sr

Answer 1

For Oracle databases, it would go something like:

SELECT First_Name || ' ' || Middle_Initial || ' ' || Last_Name AS Employee
FROM emp;

"Employee" would be your alias.
"First_Name", "Middle_Initial", and "Last_Name" would be your concatenated columns.

Answer 2

select col1+' '+col2+' '+col3 as FullName
from table
where condition

That should work in SQL Server

Answer 3

Then you need to select col1||col2||col3
That should do it. If it does not then look fro concatenation for your database.