Converting VARCHAR to CHAR

Shanu.sukoor · New User Joined: 31 Jan 2006 Posts: 32 Location: India

Hi,

I have a query which fetches a field of 255 bytes. But it is VARCHAR. What I need to do is to append spaces in the remaining bytes after the string and the length should be constant. This should be done through query itself!

So the selected string will have 255 bytes. Can I concatinate spaces with the string?

Please help me.

Thank you,

Shanu

Srihari Gonugunta · Posted: Fri Sep 28, 2007 5:10 pm

try
CHAR(varchar_col_name,254). This will return a char string of length 254. It can't be 255 as per restriction on CHAR function.

check this link for reference.
publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0000777.htm

If you need varchar-col to be of 255..probably you can do a simple concat like this
CONCAT(CHAR(varchar_col_name,254),' ')