SQLTeam.com | Weblogs | Forums

Convert Access MID Function to TSQL

Can anyone help me convert this to TSQL code?

In Access: AND ((Mid([trackingnumber],9,2))='07')
Thanks

Please provide explanation of that function with sample data and desired result

Maybe

1 Like

Thanks, @yosiasz
I converted: AND ((Mid([trackingnumber],9,2))="07")

to AND SUBSTRING([trackingnumber],9,2)='07') for TSQL

I think this is correct.