Truncating the data for TEXT fields in select query.

[sdbabultarkar]

Hi

I am using below query to retrive the data

SELECT RequestDetails
FROM Request

Where as RequestDetails is Column with Text datatype.

I am getting truncated records for select query for RequestDetails column.
I need to fetch the complete details. Kindly let me know if any one know how it can be done.

Thanks in advance
Regards
Sandeep

[balame2004]

Hi,

It won't show the complete text when you want to see in Sql browser. Please write a frontend program to show records in grid control. You can see complete string in frontend grid control. Grid control cells should be resizable.

Regards,
Balaji U

[dip_developer]

Hi

I am using below query to retrive the data

SELECT RequestDetails
FROM Request

Where as RequestDetails is Column with Text datatype.

I am getting truncated records for select query for RequestDetails column.
I need to fetch the complete details. Kindly let me know if any one know how it can be done.

Thanks in advance
Regards
Sandeep

where are u getting the truncated records..???