View Single Post
  #1 (permalink)  
Old 04-23-2008, 02:40 PM
ciojr@yahoo.com
 
Posts: n/a
Default find word greater than 17

i am looking to find the first word of a field greater than 17

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