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