Page 1 of 1

Substring using TSQL

Posted: Thu Mar 13, 2003 11:38 am
by murad
I need to remove the first and last character in my data i.e. ABCD=BC. How can do this using TSQL?

Substring using TSQL

Posted: Thu Mar 13, 2003 12:30 pm
by mark
Here's one way
sandr('>>=.=.*','\3',sandr('.*.=>>=','\1',Data))