>Hi,
> I am using Data Environment to get the result of the report. I tried to use
>SELECT * FROM Mytable WHERE myfield LIKE '890418*'
>
>but it doesn't return the any result. There are some records matched this condition in my database.
>
>Any ideas?
>Thank you

The wildcard character for SQL LIKE clause is % (percentage sign). Use it instead of the asterisk.