I think you could use pretty much the same thing.. SQLServer has the substring funstion but uses the Charindex (I think) to find the start position.. So you might want to try something like : substring(mycol, charindex(mycol, '~'), len(mycol - charindex(mycol, '~')) this hasnt been tested, so it may need some tweaking
On 4/27/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > I was once told that dealing with a list of data in MSSQL was easier than in > Oracle. Perhaps someone well versed in MSSQL could chime in with a solution. > It probably is not as hard as you think it will be to get done. > > On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: > > > > Aaron/Greg... I have M$ SQL Server 2000. I understand the premise of what > > you say... unfortunately, my CF skills are much better than my MS SQL > > skills. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:204667 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54