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).
SUBSTRING(URLdescription,PATINDEX('"#Searchstring#"',URLdescription),256)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334948
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
