Problem with SQL 7

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.....


------------------
My ICQ # 24449786..Chat me up..Thanks

Try this:

Code:

---

    SELECT * FROM ORGMST WHERE DESCR LIKE '%IN%'

---

if you want INITIAL SETTING then use this

SELECT * FROM ORGMST WHERE DESCR LIKE 'IN%'

Quote:

---

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.....

---