Jim, Yeah, I typoed. Sorry, worked with SQL Server a lot. I did mean a PL/SQL solution, however, I cannot write a PL/SQL function to utilize, so whatever SQL I use, it has to work inside a <cfquery>
To my knowledge, Oracle doesn't have a right() function, and the sql provided didn't work in Oracle. Also, I could have extensions with any number of digits, so I'm not sure that will work anyway. Still looking for a solid solution. Thanks, Dave ---------------------------------------- Return-Path: <[EMAIL PROTECTED]> Sat Feb 10 14:30:57 2007 Received: from houseoffusion.com [64.118.74.249] by mail.bizbreeze.com with SMTP; Sat, 10 Feb 2007 14:30:57 -0500 Received: from LOCALHOST by LOCALHOST with ESMTP id 4A591C6C01270B47B496A2614E792BB1 Sat, 10 Feb 2007 14:34:57 -0500 Subject: Re: SOT: SQL Question From: Jim Wright <[EMAIL PROTECTED]> Content-Type: text/plain Precedence: bulk Reply-To: cf-talk@houseoffusion.com To: CF-Talk <cf-talk@houseoffusion.com> Date: Sat, 10 Feb 2007 14:34:11 -0500 References: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> X-SmarterMail-Spam: SPF_None X-Rcpt-To: <[EMAIL PROTECTED]> Kris Jones wrote: > select case left(right(path,4),1) when '.' then right(path,3) else '' end > This will work on SQL Server (assuming all of your extensions are three characters), and possibly on Oracle(I think it now supports CASE). In your message you wanted a T-SQL solution, but said your database was Oracle. Did you mean to say a PL/SQL or possible just SQL solution? T-SQL is the proprietary version of SQL specific to Sybase and SQL Server. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4