ODBC Scalar Functions

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Microsoft Access SQL advocates the use of the ODBC specified syntax for scalar functions in a pass-through query that functions on Microsoft SQL Server. For example, to garner all rows where the absolute value of the volatility in the stock price was greater than five, apply the followingContinue reading “ODBC Scalar Functions”

LTrim, RTrim, and Trim Functions

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (String) containing a copy of a specified string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim). Syntax LTrim ( string ) RTrim ( string ) Trim( string ) The required stringargument is any valid string expression. If string contains Null, Null is returned. Query examples Expression Results SELECT LTrim(ProductDesc) ASContinue reading “LTrim, RTrim, and Trim Functions”

String functions and how to use them

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. With string functions, you can formulate expressions in Access that override text in a several forms. For example, you may want to present some of a serial number on a form. Or, you could have to join (concatenate) numerous strings together, like aContinue reading “String functions and how to use them”