Prev: Query using group
Next: Installing the Oracle Database Made Easy
From: ciojr on 23 Apr 2008 10:40
i am looking to find the first word of a field greater than 17

select businessname
from tablename
where
CHAR(' ', businessname + ' ') > 17
From: Peter Nilsson on 23 Apr 2008 22:58
ci...(a)yahoo.com wrote:
> i am looking to find the first word of a field greater than 17

Some data examples would be useful.

> select businessname
> from tablename
> where
> CHAR(' ', businessname + ' ') > 17

-- field length > 17
where length(trim(businessname)) > 17

or...

-- has any (space delimited) word of length > 17
select regexp_substr(businessname, '[^[:space:]]{18,}')
from tablename
where regexp_like(businessname, '[^[:space:]]{18,}')

or...

-- first (space delimited) word has length > 17
select regexp_substr(businessname, '[^[:space:]]{18,}')
from tablename
where regexp_like(businessname, '^[^[:space:]]{18,}')

--
Peter
 | 
Pages: 1
Prev: Query using group
Next: Installing the Oracle Database Made Easy