Problem with SQL 7

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


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

[bsmith]

Try this:

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

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