RE: Extracting a specific number of words from a string in sql

SSC Guru

Points: 323504

February 27, 2008 at 6:59 am

I know that by using regular expressions, the \b is a word boundary; it might be a space/tab/Crlf, or it might be punctuation...period comma exclamation semicolon etc.

using regualr expressions, you'd be able to grab x number of words, based on word boundaries.

that would be the best way to go, but I've only installed the extended stored procedures from the SSC Toolkit on SQL2000.

let me install on 2005 and test a few expressions.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!