blob

From: Sajid Iqbal <siqbal_at_vianetworks.co.uk>
Date: Fri, 5 Jan 2001 11:12:20 +0000 (GMT)
Message-Id: <10732.125816@fatcity.com>

How do read from a BLOB?

sw_basic_script.swText is a blob

      SELECT swname
      FROM SW_BASIC_SCRIPT
      WHERE swText like 'VAPP%'

I've tried to_char, substr.

Any Ideas

-- 
Sajid Iqbal
Database Administrator

VIA NET.WORKS
620 Birchwood Boulevard
Birchwood
Warrington
WA3 7QZ
DDI: +44 (0) 1925 484485  Fax: +44 (0) 1925 484466
Email: siqbal_at_vianetworks.co.uk
Website: http://www.vianetworks.co.uk

local touch global reach

Received on Fri Jan 05 2001 - 05:12:20 CST