How to query by keyword for image field.

[nj-tef]

If the data type of field is "varchar",w e can use "like" to query if it has
some substring.
Such as "where custom.valuevar iant like '%Verizon%' ", it will query out all
records that contains string "Verizon".
But how to do when data type of field custom.valuevar iant is "image"?
Thanks

[Simon Hayes]

Re: How to query by keyword for image field.

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

[Kevin]

Re: How to query by keyword for image field.

Thank you very much.
"Simon Hayes" <sql@hayes.ch > wrote in message
news:1122017552 .084995.312000@ f14g2000cwb.goo glegroups.com.. .[color=blue]
> 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
>[/color]