How to query by keyword for image field.
This is a discussion on How to query by keyword for image field. within the SQL Server forums, part of the Microsoft SQL Server category; --> If the data type of field is "varchar",we can use "like" to query if it has some substring. Such ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:30 AM
| ||||
| ||||
 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"? Thanks      |
|
02-29-2008, 08:30 AM
| |||
| |||
| 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 |
|
02-29-2008, 08:32 AM
| ||||
| ||||
| 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.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 > |
Linear Mode
