Paul,
SUBSTRING(URLdescription,PATINDEX('#Searchstring#',URLdescription),256)
That worked perfectly. I had never used the PATINDEX command before so I
overlooked it completely.
A little massaging of the search string to make it a wildcard matching
pattern and all is well. Thank you.
Dennis
On 7/1/2010 2:21 AM, UXB Internet wrote:
That worked perfectly. I had never used the PATINDEX command before so I
overlooked it completely.
books-on-line is your best friend when it comes to sql server.
~|
Order the Adobe
I on a project we are using the SQL 200X internal Full Text catalog to
search the database and it is finding the correct data just fine. However,
the client would like me to pull a summary of the data that matched the text
search out of the database. Just the summary of the section of the data
On 6/30/2010 5:50 AM, UXB Internet wrote:
How would I pull just the 256 byte section of the ntext field URLdescription
that matches the searchstring?
one way might be to use PATINDEX SUBSTRING (see sql server books-on-line for
details).
4 matches
Mail list logo