[ic] wildcard question

Ton Verhagen tverhagen at alamerce.nl
Fri Jul 25 15:12:43 EDT 2003

Quoting Nicholas Cook <ncook at intropolis.com>:
>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.
>Any help would be appreciated.  I am using interchange version 4.9.8.

You could use the LIKE clause:

"WHERE featured LIKE '%[control promo_type specials]'"

Best regards,


Alamerce Nederland --- Cornerstone of eBusiness
Phone +31-40-2374381    info at alamerce.nl    http://www.alamerce.nl

eCommerce Solutions -- Consulting -- Website & Interchange Hosting 

More information about the interchange-users mailing list