Hey all; I have a quick question

[Fatih235]

Hey all;

I have a quick question. I have a column car_year as varchar. How can i run this query without changing the original datatype of column_car in actual table.

select plate_number,VIN#,car_year where car_year>1998

 

[sunila7]

hi,

Try this........

select plate_number,VIN#,car_year where CAST(car_year as int)>1998

Sunil