Are there a fixed set of delimiters in use in your title field?
If so then you could look for:
(Title = 'CAP'
OR Title like 'CAP %'
OR Title like '% CAP %'
OR Title like '% CAP')
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent:
I know you can use square brackets and the carrot symbol to exclude characters.
LIKE 'CAP[^T]%'
Will give you everything that does not begin with CAPT
So I _think_ you can do this. Try it and let me know.
LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%'
You are probably
In MySQL... '%CAP %' works.
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:43 PM
To: CF-Talk
Subject: SOT: MSSQL Query help - Finding an exact word in a field
We are trying to tease out the following:
SELECT ProjNum, ClientName,
, but won't return records with CAPTAIN or
CAPITAL.
At least I think it will. Try it out. I am not in front of a MS SQL server.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 2:17 PM
To: CF-Talk
Subject: RE: MSSQL Query help - Finding
: RE: MSSQL Query help - Finding an exact word in a field
I know you can use square brackets and the carrot symbol to exclude
characters.
LIKE 'CAP[^T]%'
Will give you everything that does not begin with CAPT
So I _think_ you can do this. Try it and let me know.
LIKE
thoughts.
I _think_ you can abbreviate with a-z and 1-9 instead of typing out the
characters.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 2:27 PM
To: CF-Talk
Subject: RE: MSSQL Query help - Finding an exact word in a field
I re
6 matches
Mail list logo