Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10

    Unanswered: Search database for [expression]

    Yep, I know this will have been asked before (because I've seen it), but I can't for the life of me find a thread!

    So I've inherited this database and I need to search the whole darn thing for a single word, returning something lovely, like the table or column the thing resides in.
    Basically it's a code in one of 100+ code tables, all with inconsistant, unclear naming - YAY!

    FYI, I'm using SQL Server 200 and the word I'm looking for is "Unpaid".

    Thanks guys, girls and gurus
    George
    Home | Blog

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Try searching for solutions specifically from blindman - he posted one here once. Maybe it is on his webpage....
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I can't access his website at work (and my home PC is down!) so i'll just search the forums and if something comes up, I'll link it here
    George
    Home | Blog

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Thanks to Blindman!
    I never thought I'd need something like this, but hey, I guess I was wrong!
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I should put that code up on my google page...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •