find word greater than 17
- From: ciojr@xxxxxxxxx
- Date: Wed, 23 Apr 2008 07:40:06 -0700 (PDT)
i am looking to find the first word of a field greater than 17
select businessname
from tablename
where
CHAR(' ', businessname + ' ') > 17
.
- Follow-Ups:
- Re: find word greater than 17
- From: Peter Nilsson
- Re: find word greater than 17
- Prev by Date: Re: Query using group
- Next by Date: Installing the Oracle Database Made Easy
- Previous by thread: Query using group
- Next by thread: Re: find word greater than 17
- Index(es):