if you want INITIAL SETTING then use this

SELECT * FROM ORGMST WHERE DESCR LIKE 'IN%'

Originally posted by RickCWYong:
Nothing was returned when i execute the following statement.

SELECT * FROM ORGMST WHERE DESCR LIKE('*IN*)

BUT THE NEXT STATEMENT WORK FINE

SELECT * FROM ORGMST

I DO HAVE A RECORD IN WHICH THE DESCR CONTAINED "INITIAL SETTING"

MY SQL VERSION IS 7.00.623

PLS HELPPPPPPppppppp.....