You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Help with BLOB Column

No replies
Guest's picture
Guest

Hi Everyone,

I need your help on this query. I need to get a particular value from a column which is a BLOB datatype. Here is the sample data. The query has to get only these two values 120001(netamount) = 20($amount)

"0 13521 5 0 "13-JAN-12"0 2365 5 0 "Invoice"0 16 7 0 0.0.0.1 /bill 100000 1 0 126 9 0 1 793 5 0 "234-456789" 1 215 14 0 01 788 14 0 01 786 14 0 01 800 14 0 01 790 14 0 01 13525 5 0 "01-Dec-96"0 485 9 0 1 499 5 0 "Percentage %1 discount due to Early Payment."0 485 9 1 1 499 5 0 "^ Precent Charges"0 1678 9 0 1 106 5 0 "0000112345"1 40 7 0 0.0.0.1 /account 3456789 197 1 1505 5 0 1 109 5 0 "nl"1 17 5 0 "USD"1 13522 9 1 2 158 5 0 ""2 166 5 0 "ABDC "2 169 5 0 "2013 AB"2 167 5 0 "JOHN"2 170 5 0 "DC"0 13512 9 0 1 13518 14 0 01 13517 14 0 00 120001 20 0 00 788 14 0 00 918 3 0 0

All these data is in one line. So in this case its very diffucult to find the correct position of 120001 (netamount) = 20 ($amount) because the position is changed in rest of the data. How can I get the 120001 (netamount) = 20 ($amount) even if position changes.

Any help is appreciate

Thanks,

Any Help on this is really appreciate

Thanks