SQL and full text retrieve


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: SQL and full text retrieve

Hybrid View

  1. #1
    Rogerio Guest

    SQL and full text retrieve


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

    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: SQL and full text retrieve


    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.
    >


    Share on Google+

  3. #3
    Rogerio Guest

    Re: SQL and full text retrieve


    "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.

    Share on Google+

  4. #4
    Bill Vaughn Guest

    Re: SQL and full text retrieve


    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.
    >


    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center