text concat in WHERE?

Should I be able to:
SELECT * from t1, t2
WHERE t1.a || ' ' || t2.b = t2.c;

In other words, combine two fields from one table and a constant space
for the join with a single field in the other table?

Les Mikesell
les(at)mcs(dot)com