right

Technical Article

Extract parts of the strings from the SQL results directly by using SQL's substring-extraction API functions

  • Script

If you need to extract a substring or create a longer string by combining multiple strings, there are a few methods you can use. To extract a specific portion of a string, you can utilize a substring-extraction function.

You rated this post out of 5. Change rating

2023-05-09 (first published: )

221 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

Deciphering Data Architectures

By Additional Articles

Comments posted to this topic are about the item Deciphering Data Architectures

Learn T-SQL Querying

By Additional Articles

Comments posted to this topic are about the item Learn T-SQL Querying

performance issue, need to tune a query

By kris6363

WITH MaxD AS (select t1.* from D as t1 inner join ( SELECT ID,...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers