Skip to Content
0
Former Member
Feb 25, 2009 at 10:46 AM

Data type to be used

38 Views

Hi All,

I have a requirement where i have to fetch mutiple rows of a table and then concatenate the data of a particular field of all the rows and put it into a single variable.

I have no restrictions on the no of rows to be fetched due to which i cannot plan of the size of that single variable.

Can anyone suggest me some data type which can take variable lengths at run time. also the size limit can go beyond 255.

Please help.

Thanks,

Chandna