Are you using SQL 2000? If so then you could create a user defined function to do what you want.
Let me know, and I'll see if I can quickly throw something together. Steve -----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 9:39 AM To: CF-Talk Subject: RE: Is there SQL equivalent to CF's ListGetAt function??? Please help! thanks...I wish there was an easier fix.... -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 9:27 AM To: CF-Talk Subject: RE: Is there SQL equivalent to CF's ListGetAt function??? Please help! I don't know if this is the best way, but have a look at SubString() and CharIndex(), you might be able to use the two together to get what you need. This is on SQL Server by the way. Ade -----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:10 To: CF-Talk Subject: Is there SQL equivalent to CF's ListGetAt function??? Please help! I have a column in a db that stores data with a pipe [|] delimiter. I would like to write a SQL query that filters data based on a segment of data within a pipe delimited variable. Basically, is there SQL code that is equivalent to the psuedo CF code below? A SQL version of ListGetAt if you will??? --> WHERE FinalShipTo = ListGetAt("#getOrderInfo.FinalShipTo#","5","~") <-- I hope this makes sense... TIA - Ch� ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
