I think you'll have th reverse the charindex to this.. charindex('~',mycol) not the way I have above.
On 4/27/05, Greg Morphis <[EMAIL PROTECTED]> wrote: > 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. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204668 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