[ic] wildcard question
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]'"
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