alias pre.test { if ($chr(47) !isin $1-) { echo -a SELECT * FROM predb WHERE release LIKE $+($chr(39),$chr(37),$replace($1-,$chr(32),$chr(37)),$chr(37),$chr(39)) ORDER BY time DESC } else { set -u0 %pre.test.search.string.base SELECT * FROM predb WHERE release LIKE $+($chr(39),$chr(37),$replace($deltok($1-,-1,32),$chr(32),$chr(37)),$chr(37),$chr(39)) set -u0 %pre.test.filter.string $replace($gettok($1-,-1,32),$chr(47),$chr(32)) set -u0 %pre.test.filter.string.total $numtok(%pre.test.filter.string,32) set -u0 %pre.test.filter.string.counter 1 while (%pre.test.filter.string.counter <= %pre.test.filter.string.total) { set -u0 %pre.test.filter.output %pre.test.filter.output AND release NOT LIKE $+($chr(39),$chr(37),$gettok(%pre.test.filter.string,%pre.test.filter.string.counter,32),$chr(37),$chr(39)) inc %pre.test.filter.string.counter 1 } ;SELECT * FROM predb WHERE release LIKE '%some%string%' AND release NOT LIKE '%a%' AND release NOT LIKE '%b%' ORDER BY time DESC echo -a %pre.test.search.string.base echo -a %pre.test.filter.output echo -a %pre.test.search.string.base %pre.test.filter.output ORDER BY time DESC } }