Access IIF to SQL Statement convert

Question

I'm trying and failing miserably to convert an Access Expression to SQL query

 

The MS Access Expression strips the following field data formats to extract the middle text between the 2 hyphens

 

2C00P02-CRIW-93201 (Extracted value: CRIW)

 

Any help appreciated

Left(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),InStr(Mid([LINE_NUM],IIf(Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))=0,1,Len(Left([LINE_NUM],InStr([LINE_NUM],"-")))+1)),"-")-1)