find word greater than 17
From: <ciojr_at_yahoo.com>
Date: Wed, 23 Apr 2008 07:40:06 -0700 (PDT)
Message-ID: <e378afa6-5283-4a38-97ab-100d739fdeb4@24g2000hsh.googlegroups.com>
Date: Wed, 23 Apr 2008 07:40:06 -0700 (PDT)
Message-ID: <e378afa6-5283-4a38-97ab-100d739fdeb4@24g2000hsh.googlegroups.com>
i am looking to find the first word of a field greater than 17
select businessname
from tablename
where
CHAR(' ', businessname + ' ') > 17
Received on Wed Apr 23 2008 - 09:40:06 CDT