var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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!
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.