Substring using TSQL

[murad]

I need to remove the first and last character in my data i.e. ABCD=BC. How can do this using TSQL?

[mark]

Here's one way
sandr('>>=.=.*','\3',sandr('.*.=>>=','\1',Data))