Returns a path defined for a site in Softadmin®. If the path has parameters, use SoftadminSnippet.SetPathParameter to set values for each parameter to get a usable URL.
DECLARE @Path nvarchar(MAX) = SoftadminSnippet.PathPattern('mysite', 'DepartmentOverview');
SELECT @Path = SoftadminSnippet.SetPathParameter(@Path, 'department', 'Finance');
EXEC SoftadminSnippet.Page_Redirect
@Url = @Path;