Tags » Substring

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

Formatting phone numbers without FORMAT

Today’s post is not an especially elegant solution, or even a flashy one. It’s not some big sexy piece of existentialist SQL poetry. But it is practical, and it was a fun little challenge.  243 more words

T-sql

JavaScript substring functions

Substring (indexstart[, indexend])

Returns part of a string between indexstart and indexend, but not including indexend.
Index (indexStart) of first character is 0.  189 more words

Javascript

All Palindromes in a string

Ever had to find if a string is a palindrome , perhaps in your college assignment , well i know the problem is too easy but how aboutwe raise the bar a bit ? 206 more words