FUNZIONI STRINGA

USE tempdb;

CREATE TABLE dbo.myTable(
myString ntext NOT NULL
);

INSERT dbo.myTable VALUES(N'Stringa 1');
INSERT dbo.myTable VALUES(N'Inquire');
INSERT dbo.myTable VALUES(N'Response');
INSERT dbo.myTable VALUES(N'blabla Inquire blabla Response blabla');
INSERT dbo.myTable VALUES(N'blabla Response blabla Inquire blabla');

SELECT *
FROM dbo.myTable
WHERE myString LIKE N'%Inquire%'
AND myString LIKE N'%Response%';

/* Output:

myString
--------------------------------------
blabla Inquire blabla Response blabla
blabla Response blabla Inquire blabla

(2 row(s) affected)

*/

DROP TABLE dbo.myTable;

SELECT @@VERSION;

/* Output:

Microsoft SQL Server 2005 - 9.00.3257.00 (Intel X86) 
  Jun 12 2008 18:38:26 
  Copyright (c) 1988-2005 Microsoft Corporation
  Developer Edition on Windows NT 6.0 (Build 6001: Service Pack 1)

*/

Microsoft SQL Server  2000 - 8.00.2273 (Intel X86) 
  Mar  7 2008 22:19:58 
  Copyright (c) 1988-2003 Microsoft Corporation
  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

SELECT *
FROM dbo.myTable
WHERE myString LIKE N'%Inquire%'
AND myString LIKE N'%Response%';

/* Output:

myString
--------------------------------------
blabla Inquire blabla Response blabla
blabla Response blabla Inquire blabla

(2 row(s) affected)

*/