Working on cross-database compatibility

1 files changed, 0 insertions, 24 deletions

diff --git a/app/Module/IndividualListModule.php b/app/Module/IndividualListModule.php
index b27d09191a..e756d6bac5 100644
--- a/app/Module/IndividualListModule.php
+++ b/app/Module/IndividualListModule.php
@@ -1024,28 +1024,4 @@ class IndividualListModule extends AbstractModule implements ModuleListInterface
             $query->where($field, 'LIKE', '\\' . $letter . '%');
         }
     }
-
-    /**
-     * @param string $expression
-     * @param int    $start
-     * @param int    $length
-     * @param string $alias
-     *
-     * @return Expression
-     */
-    private function substringExpression(string $expression, int $start, int $length, string $alias): Expression
-    {
-        switch (DB::connection()->getDriverName()) {
-            case 'sqlite':
-                // SQLite also supports SUBSTRING() from 3.34.0 (2020-12-01)
-                return new Expression('SUBSTR(' . $expression . ',' . $start . ',' . $length . ') AS ' . $alias);
-
-            case 'sqlsrv':
-                return new Expression('SUBSTRING(' . $expression . ',' . $start . ',' . $length . ') AS ' . $alias);
-
-            default:
-                // SQL-92 standard
-                return new Expression('SUBSTRING(' . $expression . ' FROM ' . $start . ' FOR ' . $length . ') AS ' . $alias);
-        }
-    }
 }