Technical Article

SPLIT function

This is a port of the SPLIT function from Perl (or VBScript). It works the same way: pass a string anda separator, up to 4 characters long (you can change this),and the function returns a table with the elements.This version trims leading and trailling spaces of the elements, just for convenience.Example:SELECT    strvalFROM    master.dbo.SPLIT('a and b', […]

5 (1)

You rated this post out of 5. Change rating

2003-06-13

209 reads

Technical Article

Port from Oracle's TRANSLATE Function

Here is a port from the Oracle's TRANSLATE function to T-SQL. It gets three arguments: a string to be searched, a string with a set of characters to be found and replaced, and another set of characters as the replacements. Example: SELECT dbo.TRANSLATE('ABCDE', 'BD', 'CE') It will return 'ACCEE'.

3 (2)

You rated this post out of 5. Change rating

2002-01-03

469 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

Validating Password Expiration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Validating Password Expiration

Extracting multiple fields from one column

By JeremyU

    Hello, I have a situation. I am trying to show each  distinct...

Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances

By Parthprajapati

Comments posted to this topic are about the item Unlock the Power of Google...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers