LIKE clause

[priyam]

Hi i am using the following quesry to pick up data from product_no field in my database which has values "test" and "123" only

"SELECT * FROM report WHERE product_no LIKE 't%'

the field product_no has data type text.
but the above quesry is giving error

Please help!!

[Phill Pafford]

the query looks fine, what is the error your getting? how are you running the query? program like PHP, manually?