Post reply

Searching in Tables.

  • August 24, 2003 at 3:58 pm

    #160623

    Hi All

    I am a novice, can anyone show or tell me or have any examples on how to search for text in a table in all fields, and would it search the blob as well

    Thanks

    Steve

  • August 25, 2003 at 12:22 am

    #471146

    Hi Steve,

    quote:

    I am a novice, can anyone show or tell me or have any examples on how to search for text in a table in all fields, and would it search the blob as well

    I'm not sure, if I understand you fully.

    Are you really trying to search across all columns of a table for a string?

    Or are you trying to search only certain columns, including a text or image data type?

    Maybe it would be helpful to post some example of what you've got right now

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 25, 2003 at 10:01 pm

    #471347

    Hi Frank

    Thanks for the reply, i am tring to search for a string in a table across all columns,

    i need to find if a certain string appears in any part of the table, not in Blob or image type.

    Thanks

  • August 25, 2003 at 10:42 pm

    #471350

    Steve,

    Sometimes I used to do the same with Embarcadero DBArtisan.

    .

  • August 25, 2003 at 11:57 pm

    #471362

    quote:

    Thanks for the reply, i am tring to search for a string in a table across all columns,

    i need to find if a certain string appears in any part of the table, not in Blob or image type.

    I think I have seen somewhere a method to query this.

    Hm,...I'll keep digging and hopefully be successful

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 27, 2003 at 12:34 am

    #471538

    Thanks.

    fingers are itching....

  • August 27, 2003 at 3:08 am

    #471557

    Hope this will help you

    quote:

    fingers are itching....

    here we go.

    http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12903

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 27, 2003 at 9:49 am

    #471631

    Thanks frank, all i got to do now if to try and work it out with my programing i am writing.

    Thanks again

    Steve

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply