On Tue, Sep 17, 2002 at 11:04:53AM +0000, Rafiq Ismail (ADMIN) wrote: > Kind of typical, it came back to me after posting. > > select substring(content from 11 for 4) from FOO; > > > > > > and you'd like a where clause on the 4 characters? > thus : > SELECT substr(content,11, 15) AS fish FROM FOO where fish='fish'
That didn't work when I tried it: chisel=# select substring(content from 11 for 4) as fish from FOO where fish = 'post'; ERROR: Attribute 'fish' not found chisel=# select substring(content from 11 for 4) as fish from FOO where substring(content from 11 for 4) = 'post'; +------+ | fish | +------+ | post | +------+ (1 row) Chisel -- e: [EMAIL PROTECTED] | Buy 'em books, and they eat the w: www.herlpacker.co.uk | fscking covers. gpg: D167E7FE |