hehe...well there ya go....and FYI.....in Oracle it's the substr() functin Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, December 11, 2006 12:57 PM Subject: Re: I am having a massive brain fart
> SQL Server. And I just found the answer. LEFT operand. > > On 12/11/06, coldfusion. developer @ att. net coldfusion. developer @ att. > net <[EMAIL PROTECTED]> wrote: >> >> By the first 70 characters, do you mean the first 70 rows? >> control the number of rows with maxrows and control the list's >> order with "order by" ... Asc is default and DESC for reverse order. >> >> That's how I'd do it if I'm understanding you correctly. >> >> <CFQUERY name="" datasource="datasource" maxrows="70"> >> select * >> from tablename >> order by table_id >> or >> orderby datesubmitted >> </cfquery> >> >> D >> >> >I have a query that retrieves a list of names. I want to limit the output >> to >> >the first 70 characters. What is the SQL query to do this? >> > >> >Thanks, >> > >> >Bruce >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 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:263630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
