MS Excel CODE Function
Sometimes you may need to convert character or text data to ASCII code value in MS Excel. There is a function called CODE in MS...
MS SQL Server PADDING Function
Sometimes you may need to pad character in left or in right in MS SQL Server. There is no direct function in MS SQL Server...
MS SQL Server REPLICATE() Function
Sometimes you may need to repeat a same string in multiple times in MS SQL Server. There is a function called REPLICATE in MS SQL...
MS SQL Server SPACE() Function
Sometimes you may need to add space with your desired text in MS SQL Server. There is a function called SPACE in MS SQL Server by...
MS SQL Server STRING_ESCAPE() Function
Sometimes you may need to create JSON text from variables and escapes any special JSON character in variables in MS SQL Server. There is a...
MS SQL Server STRING_AGG() Function
Sometimes you may need to aggregate cell values of multiple rows in MS SQL Server. There is a function called STRING_AGG in MS SQL Server by...