SQL and full text retrieve

[Rogerio]

I am using SQL operators and how can i do a full text retrive
using SQL database fields.

[Bill Vaughn]

What do you mean by "full text retrieve"? Do you want SS to search for text
in TEXT fields or something else?

bv
"Rogerio" <rogeriocs@documentwarehouse.com.br> wrote:
>
> I am using SQL operators and how can i do a full text retrive
>using SQL database fields.
>

[Rogerio]

"Bill Vaughn" <billva@microsoft.com> wrote:
>
>What do you mean by "full text retrieve"? Do you want SS to search for text
>in TEXT fields or something else?
>
>bv
>"Rogerio" <rogeriocs@documentwarehouse.com.br> wrote:
>>
>> I am using SQL operators and how can i do a full text retrive
>>using SQL database fields.
>>
>

I would like to find a string between spaces inside any kind of fields (text,
integer, etc.). The string maybe placed in the begin, at the end or in the
middle of the field.

for example: If I am looking for 'John' I intend to find the record that
have the field STUDENT = 'Peter John Newman', not the record that have
the field STUDENT = 'Johnny Brown'

thanks,

Rogerio.

[Bill Vaughn]

Ah, well I don't know that you can search integer fields for strings. But
you can use the CharIndex function in SQL Server to locate strings within
VarChar or Char fields. You can also try a "Like" expression on these datatypes.
See booksonline for examples of these.

bv
"Rogerio" <rogeriocs@documentwarehouse.com.br> wrote:
>
>"Bill Vaughn" <billva@microsoft.com> wrote:
>>
>>What do you mean by "full text retrieve"? Do you want SS to search for
text
>>in TEXT fields or something else?
>>
>>bv
>>"Rogerio" <rogeriocs@documentwarehouse.com.br> wrote:
>>>
>>> I am using SQL operators and how can i do a full text retrive
>>>using SQL database fields.
>>>
>>
>
>I would like to find a string between spaces inside any kind of fields (text,
>integer, etc.). The string maybe placed in the begin, at the end or in the
>middle of the field.
>
>for example: If I am looking for 'John' I intend to find the record that
>have the field STUDENT = 'Peter John Newman', not the record that have
>the field STUDENT = 'Johnny Brown'
>
>thanks,
>
>Rogerio.
>