containing clause in local SQL

Gabriel Cherem

Delphi Developer

Sat, 12 May 2001 03:00:00 GMT

containing clause in local SQL

How do I set a query to retrieve records which a given field contains a
substring?

For instance,

SELECT * FROM mytable
WHERE name CONTAINING "smith"

results a capability not supported

- Gabriel Cherem <gabr...@projuris.com>

Wood

Delphi Developer

Sat, 12 May 2001 03:00:00 GMT

Re:containing clause in local SQL

Try

WHERE name LIKE "%smith%"

Woody

Quote

Gabriel Cherem wrote in message <73ek3l$8...@forums.borland.com>...
>How do I set a query to retrieve records which a given field contains
a
>substring?

>For instance,

>SELECT * FROM mytable
>WHERE name CONTAINING "smith"

>results a capability not supported

>--

>- Gabriel Cherem <gabr...@projuris.com>

Team

Delphi Developer

Sat, 12 May 2001 03:00:00 GMT

Re:containing clause in local SQL

SELECT * FROM MyTable
WHERE Name LIKE "%Smith%"

--
Bill Todd
(Sorry but TeamB cannot answer questions received via email)
(Remove nospam from my email address to contact me for any other reason)

Other Threads

1. SQL Union clause (Local SQL)

2. SQL where clause CONTAINING

3. Local SQL bug using OR in WHERE clauses

4. Local SQL, problem with OR operator in WHERE clause

5. SQL and the GROUP BY clause with local Paradox tables

6. Possible BUG in LOCAL SQL UNION clause

7. Local SQL - Can you search for text contained in a field

8. Local SQL, works in MS SQL, not in local SQL

9. Local SQL challenge - for all you local SQL gurus:

10. Using LOCAL-SQL or Transact-SQL with SQL-server and BDE