7 Replies Latest reply: Mar 28, 2012 10:44 AM by kgsmith5 RSS

ODBC Connection

kgsmith5

I have a Qlikview application that uses and ODBC connection to get data from a database table. I am trying to set an alias for two fields, so that the fields will appear as lowercase values. This is not working for me and I am not sure how to force the alias for the field name to be loaded as lower case.

 

SELECT


N.ACCOUNT_ID,
N.NAME_ID,
AD.ZIP_CODE,
Z.LATITUDE as latitude,
Z.LONGITUDE as longitude,
Z.DMA,
Z.STATE,
Z.STATION_SUPPORT

FROM

NAMES N,

ADDRESSES AD,

ZIP_CODE Z

 

WHERE N.ACCOUNT_ID = AD.ACCOUNT_ID

and N.PREFERRED_ADDRESS_ID = AD.ADDRESS_ID

AND AD.ZIP_CODE = Z.ZIP_CODE

When you go to the expression builder, the field names appear in all upper case, but I need them to be in lower case as the alias in the script.

Can anyone help???