Function

COMBINEPATHS

Action

Takes two paths as strings, or a path and a basename as strings. It combines them and returns the result.

Parameters

(string) Path.

(string) Path, filename, or path and filename.

Return values

(string) Concatenation of input parameters with a directory separator between them.

Examples
// Returns "c:\tmp\things\file.txt" on Windows OS
SELECT COMBINEPATHS("C:\\tmp","things\\file.txt") AS Path;
// Returns "/var/log\things/file.txt" on Windows OS
// Returns "/var/log/things/file.txt" on non-Windows OS
SELECT COMBINEPATHS("/var/log","things/file.txt") AS Path;
Notes

The function is not file system aware; it does not check to see if the path of file exists, and does not change the input strings.

The function is OS aware; it assumes the directory separator is \ on Windows and / on other OS.