This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

I need to query against a column which contains build numbers stored as an NVARCHAR.Sorting works fine until you get into double-digit versions.This works ...

Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

Problem asks for finding the maximum number of vowel letters in any substring of length k in a given string s. The approach I used to solve this problem is based on sliding window technique. Here's a ...