quote:

---

Originally posted by Vinnie881

Create a function, if you post some sample data with table structures I'll help you with it.

---

CREATE PROCEDURE SPLITIT(@id AS INTEGER, @sentence AS VARCHAR(1024)) AS
BEGIN
	DECLARE @Position AS INTEGER, @Str AS VARCHAR(50)

	SET @Position = CHARINDEX(' ', @sentence)

	IF(@Position = 0)
		INSERT INTO aaaTmpWordTable (id, Word) VALUES (@id, @sentence)
	ELSE
		BEGIN
			SET @Str = LEFT(@sentence, @Position-1)
			INSERT INTO aaaTmpWordTable (id, Word) VALUES (@id, @Str)
			SET @Str = RIGHT(@sentence, LEN(@sentence) - @Position)
			EXEC SPLITIT @id, @Str
	END
END

Go
	DROP TABLE aaaTmpWordTable
Go
	CREATE TABLE aaaTmpWordTable (id INTEGER, Word NVARCHAR(1024))

DECLARE @PCStatus VARCHAR
DECLARE @TmpId INTEGER
DECLARE @TmpWords VARCHAR(1024)

DECLARE PCcursor CURSOR FOR
	SELECT id, term 
	FROM table
	OPEN PCcursor
/* read the 1st row */
	SET @PCStatus = 0
	WHILE @PCStatus = 0 BEGIN
		FETCH NEXT FROM PCcursor INTO @TmpId, @TmpWords
		SET @PCStatus = @@Fetch_status
		IF @PCstatus <> 0 BREAK
		EXEC SPLITIT @TmpId, @TmpWords
	END
CLOSE PcCursor
DEALLOCATE PCcursor

quote:

---

Originally posted by dataguru1971

That sample code splits the words that are separated by a space. Separating them by any non alpha numeric character would be a bit more involved.

Sample data and desired results is key.

---

quote:

---

Originally posted by Vinnie881

Keep in mind how this forum is so people who may know how to resolve your issue will help you. When you post your table structure, sample data and desired results, it allows someone to quickly come in and write the code needed to resolve your issue. When that is not provided, it takes longer because it makes who ever is trying to help you need to waste time to generate their own data set, so please understand it is not irrelevent. It's not that I or other people can't figure out what you want from what you have explained, it's that it takes more time to write the code.


You do not need your exact table structure, you just need something so it gives something to work off of.

I'm sure people will be more than happy to assist once you provide that information. If you want to do it yourself, here is what I would do:

Write a function to split the text string into words and insert them into a table. You should probably split the words using the ASCII function so you can say if ASCII between 64 and 122 or Ascii between 48 and 57.

That give you all A-Z a-z 0-9 as valid charectors, if it's not that then split. You will need to factor in if you want to include "'" or anything else as valid. Like I said I would write this for you if you provided the table structure and some sample data.

---