Convert Access MID Function to TSQL

Transact-SQL
1

Can anyone help me convert this to TSQL code?

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

2

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

Maybe

1 Like
3

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

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

I think this is correct.