> Take a look at SUBSTRING. > Ade
> -----Original Message----- > From: Protoculture [mailto:[EMAIL PROTECTED] > Sent: 10 May 2005 15:32 > To: CF-Talk > Subject: MSSQL Function > I have a variable like this.. ',6,6,8,2,10,11,' > what mssql function(s) can I use to remove the commas > before the first 6 and > after the last number (11) ? If you've installed the SQL Server client tools, there's a "functions" page in the SQL Server Books Online (BOL) with a list of what's available natively and then you can write your own with SQL 2000 or later if you need something else, like I've written functions to remove the time from a datetime column (so the value is midnight of the given date) or to format a string for xml like CF's XmlFormat(). s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206227 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
