Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.
In Access, the LTrim function returns a copy of a string with leading spaces removed.
The syntax for the LTrim function is:
The string argument can be any string expression. If string contains Null, Null is returned.
This example uses the LTrim function to strip leading spaces from a string variable. Now the MyString variable would contain the value "Access ".
You can also use the LTrim function in a query.
If you'd like to see how it works, enter SQL statement and press Execute
dzone | digg | del.icio.us |