Sep 19, 2024 · SELECT RTRIM(item,'/') AS item FROM dbo.YourTable; If you aren't on SQL Server 2022+, then you'll want to REPLACE or TRANSLATE (SQL Server 2017+) the characters with …

Mar 21, 2018 · My SQL Server database input values follow a pattern of where the first position is a character and then followed by number. I want replace the first character with another character or …

Jan 13, 2016 · Explore related questions sql-server sql-server-2008-r2 t-sql replace See similar questions with these tags.

Feb 1, 2017 · Does Microsoft SQL Server natively support some sort of replace function using wild cards? I gather that Regular Expressions are not available natively. I note that there is a PATINDEX …

Mar 22, 2016 · I'm on SQL Server 2014 and I need to clean whitespace from start and end of a column's content, where whitespace could be simple spaces, tabs or newlines (both \n and \r\n); e.g.

At this time, switching to a 64-bit server is not an option for us. I know restarting the server releases whatever memory it has held, but that is not a viable solution in a production environment. Is there a …

Nov 26, 2016 · I am passing a parameter to a dynamic sql string and have the parameter properly encompassed in ' marks to work in my dynamic sql. However, now I am needing to use the value in a …

May 2, 2019 · Here's a fiddle to show what I'm after. Given a table with two columns - an integer ID and a text-based string - I want to start with a string value that encodes any number of integers wrapped …

Aug 28, 2018 · What is the difference when using or not using "With Replace" when restoring database. I know that With Replace, I would get identical database as backup file even log file would be …

Aug 17, 2022 · See this other post of mine for some context: Storing special characters (German, French, Spanish) in SQL Server result in weird strings. My database collation is as of now still …