>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only