[ic] wildcard question

[Ton Verhagen]

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,

Ton

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

eCommerce Solutions -- Consulting -- Website & Interchange Hosting