Re: SQL Like Question.

[rob@xxxxxxxxx]

Simple test in STRSQL
SELECT * FROM QTEMP/RPG400
....+.
FNAME 
TIM 
TIMMY 
PETE 
******

SELECT * FROM QTEMP/RPG400
WHERE FNAME LIKE 'TIM' 
No data selected for output.

SELECT * FROM QTEMP/RPG400
WHERE FNAME LIKE 'TIM%' 
....+.
FNAME 
TIM 
TIMMY 
******

So, in summary, yes, you do have to use the special characters.
You previous experience was either due to some good mushrooms, or, you 
filled the size of the field.  For example if I drop down the size of the 
name field.
CREATE TABLE QTEMP/RPG400a (FNAME CHAR (3 ) NOT NULL WITH DEFAULT)
INSERT INTO QTEMP/RPG400b VALUES('TIM')
SELECT * FROM QTEMP/RPG400a
WHERE FNAME LIKE 'TIM' 
....+
FNAME
 TIM 
*****

There's the exception to prove the rule.

Rob Berendt