teradata sql return string to blank column

Database
ehh
Fan

teradata sql return string to blank column

Hi,

I'm using Teradata SQL Assisstant. When I run my query, it will return string to blank column. For example, I have table 1 which consist of 'name','address' and 'age'. When I run the query, I will not get anything from 'name' and 'address' column, but there are values for 'age' column. How can I solve my problem? Thanks

3 REPLIES
Enthusiast

Re: teradata sql return string to blank column

Kindly specify the SQL Assistant Version you are using and also the structure of the table.

Trying casting name & address into varchar and check if it display the values.

ehh
Fan

Re: teradata sql return string to blank column

Hi..I'm using SQL Assistant 13.0.0.11 and fyi, I'm using Windows 7. Is it the problem?

Senior Supporter

Re: teradata sql return string to blank column

can you share a picture of the screen with the query and the result set?

You can attached files to posts...