Hi, I have a products table where the descriptions came from an outside source. These need to be manually updated at times and I'm seeing a difference between what gets returned by a SQL like '%xxx%' phrase vs a REPLACE(...) phrase. The two don't always match.
The display of the description in this store's logic uses the following: Replace(JSStringFormat(LongDesc),"\r\n","<br>","ALL") I'm just wondering out loud if it might be more expedient to store the text descriptions with <br> statements vs the cr/lf combination. At least then I could SEE the dang things and not wonder if I've missed a space or something... Suggestions? Thanks! --Ben -- Ben Conner b...@webworldinc.com Web World, Inc. 888-206-6486 PO Box 1122 480-704-2000 Queen Creek, AZ 85242 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:335687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm