SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

EmbeddedSplit8K

By Carlo Romagnano,

SELECT * FROM [dbo].[EmbeddedSplit8K]('ddd ddd [12345]  ee [abcde] ee ','[',']') --returns 12345 and abcde
SELECT * FROM [dbo].[EmbeddedSplit8K]('ddd ddd #12345#  ee #abcde# ee ','#','#') --returns 12345 and abcde
SELECT * FROM [dbo].[EmbeddedSplit8K]('ddd ddd (12345)  ee abcde( ee ','(',')') --returns 12345

Total article views: 208 | Views in the last 30 days: 208
 
Related Articles
FORUM

EmbeddedSplit8K

Comments posted to this topic are about the item [B]EmbeddedSplit8K[/B] Yet another split function.....

FORUM

Select statement of view stays 5 hours to return results......

Select statement of view stays 5 hours to return results......

FORUM

Removing Carriage Returns in a Select Statement

Having trouble removing carriage returns within a select statement on a ntext field

FORUM

how to return th Flag 1 to raise the alert or 0 to no alert from SELECT statement??

how to return th Flag 1 to raise the aleart or 0 to no alert from SELECT statement??

FORUM

how to return th Flag 1 to raise the alert or 0 to no alert from SELECT statement??

how to return th Flag 1 to raise the aleart or 0 to no alert from SELECT statement??

Tags
 
Contribute