sql server 2008 r2 - Extract part of a string in SQL -


in sql server 2008 r2 need extract string between character 50 , 60. i've searched similar function on internet didn't find can address problem.

i can on excel formula like: mid(a2, 50, 10)

the sql function called substring

  substring(fieldname,50,10) 

Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -