Alternatives · Basic Logics · Real Scenario Logic's

TRIM Functionality for INT data typed values in SQL – Issue with Solution

Introduction In this blog, we will see what is the issue when we use TRIM function in SQL for INT (Integer) data typed values and what is the solution for it. Issue - 'Argument data type int is invalid for argument 1 of Trim function.' Sample SQL Script DECLARE @A VARCHAR(10),@B INT; SET @A=' 54… Continue reading TRIM Functionality for INT data typed values in SQL – Issue with Solution

Advertisement
Alternatives · Basic Logics · Data Analysis · Data Management · Real Scenario Logic's · String Manipulation

SuperTrim Function in SQL Server

After Reading my Article - To Remove Multiple and Duplicate Spaces to Single Space in SQL Server, I received the email where one of my friend is asking for the below requirements- To Remove Invisible TAB, Carriage Return, Line Feed characters, White Spaces, Non-Breaking Spaces etc., Leading and Trailing spaces need to remove.Further, contiguous occurrences… Continue reading SuperTrim Function in SQL Server