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
|
