Perform select statement with a where condition not with same size

SELECT * FROM table

WHERE column1 = z-column.

The field column1 is of type char and size 20

The field z-column is of type char size 10.

how do we perform this select?

Anyone can guide me?

Moderator message - Welcome to SCN. But...

Moderator message - Duplicate post locked

Edited by: Rob Burbank on Sep 11, 2009 10:16 AM