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)
etc...
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
:owould you kindly give us the table names and column names involved
otherwise the most i can tell you is to use LIKE
No comments:
Post a Comment