LuYanJun <[EMAIL PROTECTED]> wrote:
Suppose there is table name Schedule and more than two records be
stored. however, one filed name as title and its values contain '%'
in one of both records , so then such SQL pharse: SELECT * FROM
Schedule WHERE title LIKE '%%%' be given , then return both records
NOT only one
I assume you want to retrieve only records where title does contain a %
character. Like this:
SELECT * FROM Schedule WHERE title LIKE '%\%%' ESCAPE '\';
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
