Re^2: Extracting only required length in a column in perl DBI

[Thomas Kennll]

in reply to Re: Extracting only required length in a column in perl DBI
in thread Extracting only required length in a column in perl DBI

That will work.. But, I actually wanted to extract 6 characters for the 3 column... How do I achieve that??

[marto]

Replace the 3 in my example with a 6, you should consider learning basic SQL.

[Thomas Kennll]

What I meant is something like this my ($ansb_cktid, $ansb_mcn, $ansb_soc) =unpack("A3 A3 A6")

[marto]

I'm of the mind set that you shouldn't pull back more data than you need then post process it, when you can easily return only what you need.