Hi All,

I have one comment field in my stored procedure which is of the size VARCHAR(200) but the database column I am fetching data from is of 500 VARCHAR.
DB2 does not truncates the text automatically and throws error when I execute my procedure. I dont want to increase the field size in my procedure so how can I restrict to fetch only first 200 characters and ignore other text?

Thanks

you could use the LEFT() function

select LEFT(<column>,200)

would select the first 200 characters from the column.

Thanks Tony, its working.