Tags » Substring

Tip - Excel formula to convert Instance Name to Server Name

Below formula will give sub string preceding \

=LEFT(A2,IFERROR(SEARCH("\",A2),LEN(A2)+1)-1)

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

Testing

Convert a string into Title case in Sqlserver

Input: This is test input data!

output: This Is Test Input Data!

CREATE FUNCTION funTitleCase
(
@str VARCHAR(1000)
)
RETURNS VARCHAR(1000)
AS
BEGIN
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