Hi,
Is there a way to programmatically determine (perhaps by interrogating the
system catalogs) if a column supports full-text searching.
In my application I want to use "CONTAINS" where support is available but
deprecate to "LIKE" where it is not.
TIA
Robin
call sp_help_fulltext_columns
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"DbNetLink" <info@.NOTTHISdbnetlink.co.uk> wrote in message
news:%23vi0o$pYFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is there a way to programmatically determine (perhaps by interrogating the
> system catalogs) if a column supports full-text searching.
> In my application I want to use "CONTAINS" where support is available but
> deprecate to "LIKE" where it is not.
> TIA
> Robin
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment