How to select text field as interger

Dear members,

My table consist off the following fields

CREATE TABLE test
(
id bigserial NOT NULL,
name character varying(100),
CONSTRAINT logs_pkey PRIMARY KEY (log_id)
)

with value :

ID Name
1 001
2 01
3 1
4 11

Select name from test where name = '1' ;

results in :

Name
1

If the 'Name' field was define as a serial the result set ought to be

Name
001
01
1

Question?

How can I have the same result set as above

Name
001
01
1

with the name field defined as character varying.

Thanks