User-Defined string Functions SQLCLR MS SQL 2005

User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net) Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net): AT(): Returns the beginning numeric position of the nth occurrence of a character expression within […]

5 (1)

2007-06-04 (first published: )

611 reads

User-Defined string Functions Transact-SQL

GETWORDCOUNT, GETWORDNUM, AT, RAT, OCCURS,CHRTRAN, STRFILTER, PADC, PADR, PADL, PROPER, RCHARINDEX etc. AT, PADL, PADR, CHRTRAN, PROPER are similar to functions Oracle PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. In my humble opinion, it will be convinient to apply such functions for writing of stored procedures and User-Defined Functions on Transact-SQL. Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115

2006-01-10 (first published: )

1,298 reads

Blogs

More Azure Blob Storage enhancements

By

I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...

Daily Coping 25 May 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

A Byte of Redgate–Bonus Queso Recipe

By

As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...

Read the latest Blogs

Forums

HTML Mail with more than one line in Resultset

By tutter

Hello all, i would like to send a html Mail with sql server. But...

AS Tabular and Sample Data in VS

By philipp

Hello all, I really need your help – I want to use the sample...

SSIS Export Flat File as Fixed Width

By Oscar_Boots

Hi Forum, I have a table that uses the script below to create fields...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers