From ac6b57f18394da7f0e0722a28afbaddc38e67e9c Mon Sep 17 00:00:00 2001
From: Greg Roach <greg@subaqua.co.uk>
Date: Tue, 4 Oct 2022 13:30:58 +0100
Subject: Fix: #4569 - SQL-Server uses non-standard syntax for SUBSTRING()

---
 app/Schema/Migration44.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'app/Schema/Migration44.php')

diff --git a/app/Schema/Migration44.php b/app/Schema/Migration44.php
index 4dd6366edd..fe77215085 100644
--- a/app/Schema/Migration44.php
+++ b/app/Schema/Migration44.php
@@ -102,7 +102,7 @@ class Migration44 implements MigrationInterface
 
             DB::table('placelocation')
                 ->update([
-                    'pl_place' => new Expression('SUBSTR(pl_place, 1, 120)'),
+                    'pl_place' => new Expression('SUBSTRING(pl_place, 1, 120)'),
                 ]);
 
             // The lack of unique key constraints means that there may be duplicates...
-- 
cgit v1.3