I think there's misunderstanding. The column names are what had the spaces in them. The guy who said
SELECT [column name] as ColumnName probably has the best solution. Trim function likely won't help in this situation at all. Allen ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of shawn gorrell Sent: Friday, April 18, 2008 9:07 AM To: [email protected] Subject: Re: [ACFUG Discuss] QoQ question How would Trim() remove an embedded space? ----- Original Message ---- From: "McTure, Greg" <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, April 18, 2008 8:54:51 AM Subject: RE: [ACFUG Discuss] QoQ question Hi Scott: Couldn’t you use a TRIM function in the original query to eliminate the spaces? In SQL Server, it would actually be something like: SELECT RTRIM(LTRIM(col_with_spaces)) FROM TABLE. ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill Sent: Thursday, April 17, 2008 4:25 PM To: [email protected] Subject: [ACFUG Discuss] QoQ question I am writing a query of query where the result set in the original query has spaces in the field names. I know when you are querying a database, you use [Field Name] as the syntax but CF is throwing an error when I do this with the QoQ. Any ideas how I can call the fieldname with spaces in a QoQ? J. Scott Councill Software Engineer II Direct: 404.601.4390 Cell: 804.267.9555 [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> Spunlogic Expect More From the Web www.spunlogic.com<http://www.spunlogic.com/?CMP=EMC-OutlookSig> Looking for insights and tips on all aspects of interactive marketing? Visit Spunlogic's Blog<http://www.spunlogic.com/blog/?CMP=EMC-OutlookSig> for a look inside the minds of a leading interactive agency. ------------------------------------------------------------- Annual Sponsor - Figleaf Software<http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink<http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor - Figleaf Software<http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink<http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor - Figleaf Software<http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink<http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
