Intervals Part 1 - Definitions and Terms
Learn the basic terms and definitions for intervals in SQL Server.
2018-03-12
1,795 reads
Definitions
RE: Substring Replacement
If the business logic is the one you wrote in your last post, try something like: declare @txt varchar(255) set @txt='MAPI:{Jones, Doug}EX:/o=Company Name/ou=Data Center/cn=Value/cn=dojones'select charindex('/cn=Value',@txt), (substring(@txt,0,charindex ( '/ou',@txt))) +'/ou=Data Center/cn=Recipients/cn='+ +(substring(@txt,charindex ( '/cn',@txt,charindex('/cn', @txt)+1) +4,len(@txt)))Will return:MAPI:{Jones, Doug}EX:/o=Company Name/ou=Data Center/cn=Recipients/cn=dojones For another string: declare @txt varchar(255) set @txt='MAPI:{Vaughn, Rickey}EX:/o=Company Name/ou=Data Center/cn=Amelia ICO - La/cn=RVaughn 'select (substring(@txt,0,charindex ( '/ou',@txt))) […]
2004-11-16
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers