Today I needed to remove the trailing slash off a URL in SQL

Did you know Skybrud Redirects package doesn't like trailing slashes in the Url column (the from URL)?

If you add redirects to the database yourself, they won't work with a trailing slash. So I needed to fix the data.

First of all I needed to make sure my WHERE criteria was correct. Here is a SELECT query with the correct WHERE criteria

SELECT [Url] oldUrl
FROM SkybrudRedirects
WHERE [Url] LIKE '%/' AND LEN([Url]) > 1

Next I wrote another SELECT statement to show what the new url would look like next to the old one.

SELECT [Url] oldUrl, LEFT([Url], LEN([Url]) -1) newUrl 
FROM SkybrudRedirects
WHERE [Url] LIKE '%/' AND LEN([Url]) > 1

Finally I wrote the UPDATE statement to make the change

UPDATE SkybrudRedirects
SET [Url] = LEFT([Url], LEN([Url]) -1)
WHERE [Url] LIKE '%/' AND LEN([Url]) > 1

All done. I ran the original SELECT query to make sure they were all gone now and they were.

I hope this helps someone else, probably just me in 6 months.

Paul Seal

Umbraco MVP and .NET Web Developer from Derby (UK) who specialises in building Content Management System (CMS) websites using MVC with Umbraco as a framework. Paul is passionate about web development and programming as a whole. Apart from when he's with his wife and son, if he's not writing code, he's thinking about it or listening to a podcast about it.

Proudly sponsored by


  • Moriyama build, support and deploy Umbraco, Azure and ASP.NET websites and applications.

  • CI/CD service for Windows, Linux and macOS
  • Build, test, deploy your apps faster, on any platform.

  • is the easy error logging and uptime monitoring service for .NET.
  • Take back control of your errors with support for all .NET web and logging frameworks.
uSync Complete

  • uSync.Complete gives you all the uSync packages, allowing you to completely control how your Umbraco settings, content and media is stored, transferred and managed across all your Umbraco Installations.

  • More than a theme for Umbraco CMS, take full control of your content and design with a feature-rich, award-nominated & content editor focused website platform.

  • Affordable, Geo-Redundant, Umbraco hosting which gives back to the community by sponsoring an Umbraco Open Source Developer with each hosting package sold.