combining columns in sql statement. (Oracle, database)

I have a select statement that is sort of like this

select drive, path, filename, “.txt” from Table where name=“foo”;

This generates a nice record set with 4 columns / row.

I need two columns per row.
I need to do that by combining drive, path and filename using string methods

drive looks like C, path looks like root, filename looks like foo
what I need those three combined together to look like is

This isn’t to be done within Xojo code but within the sql statement … somehow…

SQL Server:

select  drive + path + filename + '.txt' from table .....


One of these is likely to work on your flavour of database

The other command is CONCAT(…) to join strings i.e.

SELECT CONCAT(drive, path, filename, '.txt') FROM tableName