Re: Enbedded SQL Question

Thomas,
You would use the same condition in SQL.
Where FIELD LIKE '%value%'   The first % indicates a wild card for anything 
prior to your first character.  The second % indicates a wild card for anything 
after your last character.  Use them as needed.
 
 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer 
V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions 
Implementer V5R3 


 
----- Original Message ----
From: Thomas Gard <thomas.gard@xxxxxxxxx>
To: MIDRANGE-L@xxxxxxxxxxxx
Sent: Monday, June 26, 2006 12:02:22 PM
Subject: Enbedded SQL Question


I know this is probably a simple answer to this . .

but in query you can in the where clause with like

Field             Test   Value (Field, Number, 'C
TKPERSON          LIKE   '%4957%'

Is there somthing equivalent to that in SQL?

I think when I used Sequel way back they had 'Contains' for that kind
of search.

Im not finding an answer to this in my SQL book so thought you guys
would know if its possible.

Thanks