declare @mylist nvarchar(100), @delimiter VARCHAR(2)

set @mylist = 'A,B, C, D , 1, 2,345, EFG, H, '

set @delimiter = ','

select@mylist list,

(LEN(@mylist) - LEN(replace(@mylist,@delimiter,'')))/LEN(@delimiter)

+

case when right(rtrim(LTRIM(@mylist)),1) = @delimiter then 0 else 1...

Yet another way to get last day of the month

Select DATEADD (mm, DATEDIFF (mm, 0, getdate ()) +1,-1)

To get the number of times a particular string occurs in another string

DECLARE @STR VARCHAR(100) = 'ABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDEABCDE'

DECLARE @SEARCH VARCHAR(10) = 'A'

-- TO GET THE NUMBER OF OCCURRENCE COUNT

SELECT...