Sunday, February 19, 2012

How to query by keyword for image field.

If the data type of field is "varchar",we can use "like" to query if it has
some substring.
Such as "where custom.valuevariant like '%Verizon%' ", it will query out all
records that contains string "Verizon".
But how to do when data type of field custom.valuevariant is "image"?
ThanksIt would depend what type of data you've stored in the image column,
but full-text search supports querying text and Office (Word etc.
documents) data in an image column - see "Filtering Supported File
Types" in Books Online.

Simon|||Thank you very much.
"Simon Hayes" <sql@.hayes.ch> wrote in message
news:1122017552.084995.312000@.f14g2000cwb.googlegr oups.com...
> It would depend what type of data you've stored in the image column,
> but full-text search supports querying text and Office (Word etc.
> documents) data in an image column - see "Filtering Supported File
> Types" in Books Online.
> Simon

No comments:

Post a Comment