</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">DataObjects for .NET</div> <div id="PageTitle"><div id="PageTitleText">Other Functions</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="dataobjectsfornetent.html">DataObjects for .NET (Enterprise Edition)</a> > <a href="featuresandtechnique.html">Features and Techniques</a> > <a href="dataobjectsfornetexp.html">DataObjects for .NET Expressions</a> > Other Functions</td></tr></table></div> <div id="BodyContent"> <p>Other functions include:</p> <table style="HEIGHT: 212px; WIDTH: 83.67%"> <tbody> <tr> <th>Function</th> <th>Description</th> </tr> <tr> <td>Convert(value, type)</td> <td>Converts a value to the specified type. Example: Convert(Quantity, 'System.Int32')</td> </tr> <tr> <td>Len(string)</td> <td>Returns the length of a string. Example: Len(CompanyName)</td> </tr> <tr> <td>IsNull(value, replacement_value)</td> <td>Returns value if it is not Null and replacement_value if value is Null. Example: IsNull(OrderDate, #1/31/2001#) returns #1/31/2001# if Orderdate is Null.</td> </tr> <tr> <td>IIF(condition, true_value, false_value)</td> <td>Returns true_value if condition is <b>True</b>, and false_value if condition is <b>False</b>. Example: IIF(A < B, A, B) returns the minimum of A and B.</td> </tr> <tr> <td>Substring(string, start_position, length)</td> <td>Returns a substring of specified length starting at start_position. Example: Substring(CompanyName, 1, 5) returns first five characters of the CompanyName value.</td> </tr> </tbody> </table> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a target="_blank" href="http://our.componentone.com/groups/">Product Support Forum</a> | <a target="_blank" href="http://feedback.componentone.com/forums/255782-winforms-documentation">Documentation Feedback</a> </div> </body> </html>