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', […]
2003-06-13
208 reads
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'.
2002-01-03
468 reads
And no, the answer is not because you want to be a Microsoft MVP....
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
Recently I had an interesting use case where I had to a compound calculation...
Error code 15271in QuickBooks is common error of the 15x series. A QuickBooks Error...
Now all men can solve the problem of erectile failure at the time of...
Hi. In source SQL Instance target linked server has been created and connection tested...
Ask SSC