The functions reference PDF will be updated for V7.
The NZ function will go on the Monarch 8 future features list.
The String issue is resolved in V7, with the addition of a fill argument to the STR function,
This will convert Account_No to a string of 15 characters with no decimals, using the * character to fill up to 15 characters.
Will the [url="http://www.datawatch.com/vortexmlsupport/Revised_Monarch_Functions_Reference_Guide.pdf"]Monarch Functions Reference Guide[/url] be updated soon with the new functions available in V7?
Also, I had mentioned a function that's available in Access, called Nz(), Syntax:
Which would replace the following IF() function:
Another interesting string function is String(), Syntax:
This would be nice when you need to pad a string with a certain number of characters, especially when you want to pad more than 10+.
Just some thoughts. /b[/quote]