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: )

612 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,305 reads

Blogs

Power BI Monthly Digest – August 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 14 Aug 2020

By

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

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Location Data Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Location Data Privacy

TextBox Property>Action>GotoURL for Multiple Values?

By jbalbo

Hi I am using two stuff commands in my query. One gets the date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers