When you apply a function to a table in Query Designer, the output column name in the Content Browser is different for different databases and may bear no relation to the source column name. For example:
DBMS |
Function |
Query in Query Designer |
Source column name |
Output column name |
|---|---|---|---|---|
IBM DB2 |
CHAR |
select CHAR(col_1) from DATE_TBL |
COL_1 |
1 |
Adaptive Server |
convert |
select convert(char(10), ID) from CUSTOMER_TBL |
ID |
col_1 |
Sybase IQ |
convert |
select convert(char(10), id) from alt_sales_orders |
id |
id |
Microsoft Access |
SUM |
select SUM(SA_TOTAL) from SALES |
SA_TOTAL |
Expr1000 |
You must use column aliases when you enter queries in Query Designer so that the column alias displays as the output column name. For example, using the column alias mycolumn:
select CHAR(col_1) as mycolumn from TEST_TBL
