<div>Sorry I spoke so hastily before engaging my brain. The rtrim function made no difference, however I will root around and see if it is some other formatting issue in Excel 2003.</div>
<div> </div>
<div>Dan<br><br></div>
<div class="gmail_quote">On Wed, Jul 28, 2010 at 2:57 PM, DGK <span dir="ltr"><<a href="mailto:kerrcad@gmail.com">kerrcad@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">
<div>It's an Excel Spreadsheet. What is " RTRIM(Status) = 'Mounted' " and will it still help in this case?</div>
<div> </div>
<div><br> </div></div>
<div>
<div></div>
<div class="h5">
<div class="gmail_quote">On Wed, Jul 28, 2010 at 2:54 PM, GordonL [via OSGeo.org] <span dir="ltr"><<a href="http://user/SendEmail.jtp?type=node&node=5346127&i=0" rel="nofollow" target="_blank">[hidden email]</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">I would recommend, RTRIM(Status) = 'Mounted' <br><br>SQL will put spaces on the end... <br><br><br>
<br>
<hr color="#cccccc" size="1" noshade>
<div style="FONT: 11px tahoma,geneva,helvetica,arial,sans-serif; COLOR: #666666">View message @ <a href="http://osgeo-org.1803224.n2.nabble.com/Manually-Themed-Point-Layer-tp5346110p5346123.html?by-user=t" rel="nofollow" target="_blank" link="external">http://osgeo-org.1803224.n2.nabble.com/Manually-Themed-Point-Layer-tp5346110p5346123.html</a> <br>
To unsubscribe from Manually Themed Point Layer, <a rel="nofollow" link="external">click here</a>. </div><br></blockquote></div><br><br clear="all"><br></div></div>
<div class="im">-- <br>My goals are to become incredibly wealthy and remain completely anonymous. I'm halfway there...<br><br></div>
<hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Manually-Themed-Point-Layer-tp5346110p5346127.html" target="_blank">Re: Manually Themed Point Layer</a>
<div>
<div></div>
<div class="h5"><br>Sent from the <a href="http://osgeo-org.1803224.n2.nabble.com/MapGuide-Users-f1803227.html" target="_blank">MapGuide Users mailing list archive</a> at Nabble.com.<br></div></div><br>_______________________________________________<br>
mapguide-users mailing list<br><a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>My goals are to become incredibly wealthy and remain completely anonymous. I'm halfway there...<br>