query probelm for selecting right

[midora]

Hi,

i have oracle database on 9.2.0.6 and i am tring to do following:

select testid,test_NAME, cast(testid as varchar(12)) as New_ID from test.test_hrd
where test_name like '%mc%'

i get return but both new_ID and testid are same, the testid is 14 character and i need to select 12 in new column?

how can i do that?

[Gabor]

Wouldn't

select testid,test_NAME, substr(testid,1,12) as New_ID from test.test_hrd
where test_name like '%mc%'

work?