SubStr SQL Function to get sub string

The SubStr(String Or Value , Start Position , [ Length ]) function takes either two or three parameters and returns the substring. It works with all datatypes, null will return NULL start position and length should be within string length or first parameter length.

SELECT SubStr('SQLDatabase.Net', 4) /* returns : "Database.Net" start returning from 4th character */;

SELECT SubStr('SQLDatabase.Net', 4, 8) /* returns : "Database" start returning from 4th character till 8th character */;

SELECT SubStr(1234567890, 4) /* returns : "4567890" */;

SELECT SubStr(1234567890, 4, 4) /* returns : "4567" */;