Sql-Server-Query-World

Step 1: Create a function that will accept the "text string" and "character" where we want to split the string:ALTER FUNCTION [dbo].[funSplit] ( @Texto varchar(max), @Splitter varchar(3) ) RETURNS @Lista TABLE ( rowData varchar(8000) ) AS BEGIN DECLARE @Pos Smallint While len(@Texto)>0 BEGIN

Read More