View Single Post

   
  #1 (permalink)  
Old 04-24-2008, 07:07 PM
ciojr@yahoo.com
 
Posts: n/a
Default using LEN to find a first word greater than 17

how do i write a sql (ORACLE) statement for where the first word in
the name field is greater than 17 chars?
if i do this

SELECT businessname
FROM tablename
WHERE LEN(businessname) > 17;

it will return all records when the combined length of words is
greater than 17.
i only want to check if the first word is greater than 17


Reply With Quote