Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    London, UK

    Unanswered: help! trying to find records inside text string

    Hi, got a problem and can't figure this one out.

    basically i've got a field containing a value '(14)(12)(33)(22)' and i want to compare it to a table containing those values in separate cells...

    record 1 : (01)
    record 2 : (02)

    and i want to compare this one field to those records to see whether that text string contains anything the table contains.

    i've tried ContainsTable & IN but still can't figure this out.

    any help greatly appreciated

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    would you kindly give us the table names and column names involved

    otherwise the most i can tell you is to use LIKE | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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