Even so, it is not likely to be over 2 Billion Characters in length is it?
-----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 27 April 2005 15:42 To: CF-Talk Subject: RE: ListGetAt in a SQL Select Statement... is this possible? its way more than just an address. and yes, it is probably overkill. i'm working with someone else's code. -----Original Message----- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 10:39 AM To: CF-Talk Subject: Re: ListGetAt in a SQL Select Statement... is this possible? TEXT for an address? seems like that would be overkill....anway it should cast easily enough. Adam H On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: > would this be done in the select statement? the field type for the column is > 'text' and not 'varchar'. > i think there would be issues with using charindex on a 'text' field. ugh > again... > > Che > > -----Original Message----- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 27, 2005 10:28 AM > To: CF-Talk > Subject: Re: ListGetAt in a SQL Select Statement... is this possible? > > 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:204682 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