| Author |
How to query by keyword for image field.
|
|
| nj-tef 2005-07-22, 3:23 am |
| 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"?
Thanks
| |
| Simon Hayes 2005-07-22, 3:23 am |
| 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
| |
|
| Thank you very much.
"Simon Hayes" <sql@hayes.ch> wrote in message
news:1122017552.084995.312000@f14g2000cwb.googlegroups.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
>
|
|
|
|