Re: Enbedded SQL Question

Sure, that works, too, but adds some processing, I believe. Using the sort 
sequence with appropriate indexes will likely be faster, although that 
statement is in the realm of Joe P.'s favorite speculation-land.

Vern
-------------- Original message -------------- 
From: rob@xxxxxxxxx 

What about simply using the UPPER bif? 

Rob Berendt 
-- 
Group Dekko Services, LLC 
Dept 01.073 
PO Box 2000 
Dock 108 
6928N 400E 
Kendallville, IN 46755 
http://www.dekko.com 





vhamberg@xxxxxxxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx 
06/27/2006 05:55 PM 
Please respond to 
Midrange Systems Technical Discussion 


To 
Midrange Systems Technical Discussion 
cc 

Subject 
Re: Enbedded SQL Question 






The LIKE predicate of SQL is just like that of Query/400. As to case 
sensitivity, it is set in interactive SQL using F13 to change session 
settings. In embedded SQL you can execute SET OPTION SRTSEQ=*LANGIDSHR to 
make it case-insensitive - this affects all comparison operations in the 
module. Other values are *LANGIDUNQ, *HEX, *JOB, *JOBRUN, or a table with 
sort specifications (*TBL object type). More on the in the SQL Reference. 

Query/400 has similar options - more, actually - in the collating sequence 
item. 

Vern 

-------------- Original message -------------- 
From: Al Mac 

I love the LIKE of query/400, use it a lot. 
Regular RPG has SCAN which works similarly. 
Important difference is if case sensitivity is involved. 

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 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 

list 

To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l. 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l. 


-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l.