Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data in 'schema1.fieldx' contained in data in 'schema2.fieldx'?

Status
Not open for further replies.
dangray

dangray

Programmer
Feb 3, 2003
3
US
It appears that a 'LIKE' works only on strings. What I need to do is essentially the following: schema1.fieldx contains data '00014'. schema2.fieldx contains data '00014 00015 00018 00019'. I need a qualification that fires when the data in schema1.fieldx in contained in the data in schema2.fieldx. Possible? TIA.
 
Sort by date Sort by votes
In answer to my own question, qualification would look like
'schema2.fieldx' LIKE ( "%" + $schema1.fieldx$ + "%" )
 
Upvote 0 Downvote
Hello dangray:

Two things: First make sure the QBE on schema2.fieldx is set to anywhere. Second the qual that you're looking for is 'schema2.fieldx' LIKE ("%" + $schema1.fieldx$ + "%")

ciao

john
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

krzywica
  • Locked
  • Question
How to Hyperlink Remedy HDC's in Excel
Replies
0
Views
252
krzywica
krzywica
SharedResource
  • Locked
  • Question
Spell Checker in Remedy 7.0
Replies
1
Views
305
landofcleve
landofcleve
diskpanic
  • Locked
  • Question
BMC Remedy 7.1 - anyone know how form views are stored in Remedy 7.1?
Replies
1
Views
269
diskpanic
diskpanic
heathercraw
  • Locked
  • Question
Adding License in AR System 5.x
Replies
0
Views
64
heathercraw
heathercraw
vermaj
  • Locked
  • Question
Extract user list in Remedy
Replies
0
Views
47
vermaj
vermaj

Part and Inventory Search

Sponsor

Back
Top