Basic Logics · Real Scenario Logic's · String Manipulation

Counting Number of Occurrences of a Particular Word inside the String Using T-SQL

Introduction In this blog post, we will see how can we easily find the number of occurrences of a Particular Word inside the String Using T-SQL. Check our previous post for Finding Number of Occurrences of a Particular Character in the String. Finding Number of Occurrences of a Particular Word inside the String LOGIC The… Continue reading Counting Number of Occurrences of a Particular Word inside the String Using T-SQL

Advertisement
Basic Logics · Real Scenario Logic's · String Manipulation

Finding Number of Occurrences of a Particular Character in the String Using T-SQL

Introduction In this blog post, we are going to see how can we easily find the number of occurrences of a Particular Character in the String Using T-SQL. Finding Number of Occurrences of a Particular Character in the String LOGIC The Difference between the Length of String and Length of String without considering given particular… Continue reading Finding Number of Occurrences of a Particular Character in the String Using T-SQL

Alternatives · Basic Logics · Real Scenario Logic's · String Functions · String Manipulation

To Remove Multiple and Duplicate Spaces to Single Space in SQL Server

In this blog post, we would see some of the easy methods to remove Multiple as well as Duplicate Spaces to Single Space using T-SQL in SQL Server like below. METHOD 1 - WHILE LOOP AND REPLACE By Using WHILE Loop, we can check the occurrences of double spaces, as Loop Condition.Till the occurrence (Loop)… Continue reading To Remove Multiple and Duplicate Spaces to Single Space in SQL Server