ALLTRIM( ) Function

Removes all leading and trailing spaces or parsing characters from the specified character expression, or all leading and trailing zero (0) bytes from the specified binary expression.

ALLTRIM(Expression [, nFlags] [, cParseChar [, cParseChar2 [, ...]]])

Parameters

Expression

Specifies an expression of Character or Varbinary type to remove leading and trailing spaces or 0 bytes from, respectively.

nFlags

If… Else… EndIf statement

If [Statement] then                              &n

 What are the differences between FoxPro and MS SQL Server?

Display the records/fields by using commands

Using List command

• List Specific field: List fields [field’s name] E.g.