http://www.perlmonks.org?node_id=1013392


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

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

  • Comment on Re^3: Extracting only required length in a column in perl DBI

Replies are listed 'Best First'.
Re^4: Extracting only required length in a column in perl DBI
by Thomas Kennll (Acolyte) on Jan 15, 2013 at 13:08 UTC
    What I meant is something like this my ($ansb_cktid, $ansb_mcn, $ansb_soc) =unpack("A3 A3 A6")

      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.