I think you would just use the mid function although I've never tried it on a query of a query.
Kirk -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roland Collins Sent: Thursday, March 17, 2005 2:07 PM To: [email protected] Subject: [CFCDev] OT: QoQ Substring? Sorry for the off-topic, guys, but I can't find the answer anywhere. Does anyone know if it's possible to do a SUBSTRING (or any way to grab a chink of a string) in Query Of Queries? Here's what I'm trying to do: <cfquery dbtype="query" name="qryFiles"> SELECT SUBSTRING(name, 15, 4) AS year, SUBSTRING(name, 13, 2) AS month FROM qryFiles </cfquery> I see that SUBSTRING is a reserved word in QoQ, but the function doesn't work, and I can't find anything in the CF7 docs about it! TIA, Roland ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
