Table column value showing 'blank' when the value is too large.

[Anonymous]

Hi,

I have a table with three columns(ID,Name,Address). I am loading a "Select" query to fetch the values form a View in data load.

But for one ID the Address column value is showing as blank even though the value is present in the database.

I suspected that as the value is too large and is not being fetched properly.

I tried changing the content(sub string 400 characters) of ID and value displayed as expected.

is there any way to show the value? even though the value is too large.

Please help me on this issue.

Many thanks!

Raghuveer

[Anil_Babu_Samineni]

May be share few rows and result set that demonstrates the issue?

[zebhashmi]

try to fetch with left(Address,10) to see if the length is an issue

[Anonymous]

Hi Jahanzeb,

Thank you! it worked now.

I used lenghth() instead of hard coding value.

:- left(Address,length(Address))

[shiveshsingh]

Can you share the value which is not showing?

[Anonymous]

Hi Shivesh,

My column value is more than 523 characters.