sql server full text search: How to break the words -- sql server full text search

Re: How to break the words

Hilary Cotter
2/24/2005 9:28:23 AM

sql server full text search:

This question should be posted in the Microsoft.public.sqlserver.programming
newsgroup

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

How to break the words

Pro
2/24/2005 12:37:18 PM

Hi,

I have a table which data is organized as follows,

Style Color Size_Qty
MEW6SQ215 101 XS,12; S,12; M,10;
MZ10E727L 360 29,2;30,4;31,6;32,4;33,2;
M002U2402 387 S,34; M,54; L,35;XL,17;
M002D6502 100 XS,137; S,502; M,499; L,212;

How can I using a query to form the record as following
Style Color Size Qty
MEW6SQ215 101 XS 12
MEW6SQ215 101 S 12
MEW6SQ215 101 M 10
MZ10E727L 360 29 2
MZ10E727L 360 30 4
..
..
..
..

Thank you.