View Single Post

   
  #2 (permalink)  
Old 04-24-2008, 06:07 PM
Plamen Ratchev
 
Posts: n/a
Default Re: using LEN to find a first word greater than 17

This is SQL Server newsgroup, so here is how you can do it in SQL Server.
For Oracle you have to check the Oracle newsgroups.

CREATE TABLE Foo (
keycol INT PRIMARY KEY,
businessname VARCHAR(50));

INSERT INTO Foo VALUES(1, 'Tools');
INSERT INTO Foo VALUES(2, 'Someverylongbusinessname Inc.');
INSERT INTO Foo VALUES(3, 'Short Inc.');
INSERT INTO Foo VALUES(4, 'Anotherverylongbusinessname');

SELECT businessname
FROM Foo
WHERE CHARINDEX(' ', businessname + ' ') > 18;

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Reply With Quote