Tags » Substring

What is the syntax to return a substring?

#to return a single character
#use (-) sign to reverse order of index, keep in mind that -0 and 0 are the same
"<your string here>"[<index of the character you want to return>] 60 more words

Tip - Excel formula to convert Instance Name to Server Name

Below formula will give sub string preceding \


How to split comma separate string in Sql server

This is common requirement for almost every developer to extract data from comma separated string. In Sql Server 2016, we have STRING_SPLIT  inbuilt function to extract data from string. 283 more words

Sql Server

Extracting substrings with StringUtils from the Apache library

Following on from some of my earlier posts, where I described some of the useful utils from the apache.commons.lang3 library (like that very nice RandomStringUtils class), this time I will focus a bit on the StringUtils class.  1,828 more words


Convert a string into Title case in Sqlserver

Input: This is test input data!

output: This Is Test Input Data!

@str VARCHAR(1000)
DECLARE @counter INT = 0, @length INT = 0;

45 more words
Sql Server

Convert varchar to date

As you can see from the Snippet below, the date (nvarchar) is in US format; we want to convert this to UK format.

If you don’t want to convert it to a date, or you just want to convert it to a readable UK format, simply remove the… 137 more words

Convert Date Time