data conversion

[chongo1]

hi guys i have an sql query that alters a view by changing the data type of a column from varchar to int but keeps giving me this error "Conversion failed when converting the varchar value 'File N' to data type int." here is the sql query

ALTER VIEW V_IMPORT_RECORDS
AS 
SELECT
case when cast(left(right(IMPORT_RECORDS.whichfile,44),6)as integer) = '010182' then 'RD100'
when cast(left(right(IMPORT_RECORDS.whichfile,44),6)as integer) = '010181' then 'RD99' else 0 end as 'MachineName'
FROM Import_Records

[Rabbit]

Please use code tags when posting code or formatted data.

You are getting that error because you are trying to convert the string 'File N' to a number, which is impossible.