MS access to sql migration issue : I have a sql query below
select LTRIM(RTRIM(Sub string([Short Description],9,Len([Short Description])-8))) AS PolicyNumber from x table

its giving error as this
Msg 537, Level 16, State 3, Line 10
Invalid length parameter passed to the LEFT or SUBSTRING function.