Here you go:
The output is 'Nira' - SQL Server will start from the 1st character, and return a total of 4 characters. (Please note that unlike C++ or other programming languages, string manipulation in SQL Server does not use a 0-based index)
This is same as the Statement 01. If the start position is negative, SQL Server gracefully handles this scenario and starts from the beginning of the string.
The length has to be a positive integer. Since the length parameter here is (-2), SQL Server will generate an error (which one, I don't know because for that I would have to use SSMS :))
By the way - this would make a good T-SQL Interview question. You may want to repost this one (or provide a link to this post) in the Interview Questions module of the site (http://beyondrelational.com/modules/17/interview-questions.aspx?s=stream&tab=interview-questions).
commented on Jul 14 2012 2:00PM