Re: OT: Help with SQL SELECT on Varchar from character 0..n

[Rafiq Ismail (ADMIN)]

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'

Cheers.

rafiq