Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    England
    Posts
    26

    Unanswered: user entered % in text field

    One of my users has entered "Mr % Mrs Smith" for a customer name instead of "Mr & Mrs Smith".

    How do I write a query where I can pick up on any morecustomers like this? Tried like '%%%' but this just brings up every single customer!

    Thanks,
    Beth
    Beth

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: user entered % in text field

    Is this Oracle? If so you can do this:

    WHERE name LIKE '%\%%' ESCAPE '\'

    This tells Oracle to treat '\%' as the character '%' rather than the wildcard.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •