Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-29 : 22:58:15
|
Janus writes "Hello!
I've a text, i've snippet this one here from 4guys:
-------------------------------
"Having trouble connecting to a database? ADO giving you problems? If you're confused about a database-related issue, here's the place to ask! To post a question, simply click on Start a New Thread button below!"
--------------------------------
How do I search the text for the words between 'trouble' and database?? Using pure SQL, is it possible or whats the solution?
The result should be: 'connecting to a'
It should not return the whole record but only the text in between!
If it makes it easier, it could also be pure HTML-sourcecode :)
Don't want to have a roundtrip to the IIS, just to prove the result. It's a matter of performance! - Only want to add the result into another table :O) - maybe i should use a stored procedure?, or T-SQL, and if so; I would appreciate some hints on building it :O)
Im using SQL7.0 / 2000
Kind regards
Janus" |
|
|
|
|
|
In between, selecting specific words out of...?