Character Functions Function Syntax Description CONCAT CONCAT(char1, char2) returns char1 concatenated with char2 LOWER LOWER(char) returns char, with all letters lowercase UPPER UPPER returns char, with all letters uppercase LTRIM LTRIM(char [, set ]) removes from the left end of char all of the characters contained inset RTRIM RTRIM(char [, set ]) removes from the… Continue reading Common SQL Expressions For Saved Search
Tag: Formula
Formula to categorize Asset and Liability Account From Account Number
TRS-900 Mostly chart of accounts is categorized by account type and account description. If we need to distinguish accounts from account number we can use formula text when searching accounts. If asset accounts number were starting with the character ‘1’ and liability accounts were starting with ‘2’ we can use the following formula to distinguish… Continue reading Formula to categorize Asset and Liability Account From Account Number