[ic] wildcard question

Stefan Hornburg racke at linuxia.de
Fri Jul 25 15:12:57 EDT 2003

On Fri, 25 Jul 2003 08:02:50 -0400
Nicholas Cook <ncook at intropolis.com> wrote:

> Currently, "WHERE featured = '[control promo_type specials]'" only pulls 
> what is specifically asked for, in this case everything from table 
> merchandising:featured that is marked as a "specials".  I want to be 
> able to use a wild card in this phrase like "WHERE featured = '[control 
> promo_type *specials]'" so that everything from the 
> merchandising:featured that ends with "specials" gets pulled.

What about "WHERE featured like '%[control promo_type specials]'" ?


LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

More information about the interchange-users mailing list