-
Notifications
You must be signed in to change notification settings - Fork 13
SQL capitalization column
Tako Lee edited this page Mar 11, 2014
·
3 revisions
Column name has a dedicated case option.
Option: fmt106_case_column_name = upper, type: TFmtCase.
SELECT DEPARTMENT_ID,
Min( SALARY )
FROM employees
GROUP BY DEPARTMENT_ID User can also specify a column mapping file that all columns should be capitalized exactly the same as the one in this file. Column name in this mapping file should be one column per line with desired case. If column name is not found in this mapping file, then case option for column name applied.