How to change data type when query?

[011179]

Dear all,

I want to chnage a VARCHAR column into decimal when query.
e.g. create table sample {id VARCAHR(10), value VARCHAR(10))

How can I query the table for value > 40 ?

Thanks!

 

[legacy370]

Cast the Varchar to a decimal. For example

select * from fcm00.ic_umatrix
where decimal(umat_keypart1) > 100

 

[011179]

Thanks