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
<!--a:link
{}
span.MSOHYPERLINK
{}
a:visited
{}
span.MSOHYPERLINKFOLLOWED
{}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:Calibri;}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle17
{font-family:Calibri;color:windowtext;}
span.EmailStyle18
{font-family:Arial;color:navy;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
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]:[EMAIL PROTECTED] On Behalf Of ScottCouncill
Sent: Thursday, April 17, 20084:25 PM
To: [email protected]
Subject: [ACFUG Discuss] QoQquestion
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]
Spunlogic
Expect More From the Web
www.spunlogic.com
Lookingfor insights and tips on all aspects of interactive marketing? Visit
Spunlogic's Blogfor a look inside the minds of a leading interactive agency.
-------------------------------------------------------------
Annual Sponsor - Figleaf Software
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
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor - Figleaf Software
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
