Version: 5
restore

Contents

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 joining path delimiter that is either \ or / depending on the OS filesystem.

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

This function is filesystem aware, in order to determine the joining path delimiter.