Free User-Defined string Functions Transact-SQL

Question

Free User-Defined string Functions Transact-SQL

Igor Nikiforov

SSC Enthusiast

Points: 128
More actions
April 17, 2005 at 2:43 pm

#60832

http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Description
GETWORDCOUNT() Counts the words in a string
GETWORDNUM()   Returns a specified word from a string
AT() Returns the beginning numeric position of the first occurrence of a character expression within
      another character expression, counting from the leftmost character
RAT() Returns the numeric position of the last (rightmost) occurrence of a character string within
      another character string
OCCURS() Returns the number of times a character expression occurs within another character expression
PADL()   Returns a string from an expression, padded with spaces or characters to a specified length on the left side
PADR()   Returns a string from an expression, padded with spaces or characters to a specified length on the right side
PADC()   Returns a string from an expression, padded with spaces or characters to a specified length on the both sides
PROPER() Returns from a character expression a string capitalized as appropriate for proper names
RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but the search of which is on the right
For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hey, you code might be good, but it is *not* necessary to post it to every single forum here. Most members do follow all fora here anyway.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Igor Nikiforov SSC Enthusiast Points: 128 More actions · Answer 2

Hi !

Dear Frank Kalis, my code is very good.

On other forums of the message leave downwards the next day.

Can be to whom that in the given moment the function

"Returns a specified word from a string" is necessary?

With best personal regards, Igor.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Igor,

I haven't looked at it, but I don't question the quality of your code. All I wanted to say is, that 1 post in the right forum is all that is necessary. Reading 4 times the same is a bit annoying.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

philcart SSC-Forever Points: 47794 More actions · Answer 4

Then maybe posting this to the forums is the wrong approach.

How about posting it to the script library, or talk to the guys running the site on how it may be added to the Resources Center.

--------------------
Colt 45 - the original point and click interface

Igor Nikiforov SSC Enthusiast Points: 128 More actions · Answer 5

Dear Frank Kalis

Could you please have a look at my code and let me know your opinion?

If your opinion is positive, would you be able to publish my functions, on any SQL server forums (including in Germany) that you find appropriate.

Please include your comments and designate yourself as the person who promotes this publication.

Could you please let me now if you speak French, unfortunately, I don't speak English.

With best personal regards, Igor.

Dear phillcart

You are certainly right.

Could you please have a look at my code and let me know your opinion?

If your opinion is positive, would you be able to publish my functions, on any SQL server forums (including in Australia) that you find appropriate.

Please include your comments and designate yourself as the person who promotes this publication.

Could you please let me now if you speak French, unfortunately, I don't speak English.

With best personal regards, Igor.

philcart SSC-Forever Points: 47794 More actions · Answer 6

Igor

If you would like to publish your functions at our Australian site feel free to do so. After registering at the site, post your functions in the resources section http://www.sqlserver.org.au/Resources/Registered/SubmitResource.aspx. (You will need to provide the scripts in a Zip file)

From there the Site Admins will review if they're appropriate and approve them. Posting them in the resources section automatically creates a related forum thread, tracks how many downloads there has been and allows other registered users to supply a rating.

As I am involved with producing and moderating the content of the http://www.sqlserver.org.au website, it is not appropriate for me to promote any products on that site.

And no, I don't speak French.

--------------------
Colt 45 - the original point and click interface

Frank Kalis SSC Guru Points: 111183 More actions · Answer 7

I've downloaded the code and drop you a private mail when I had a look at it. In the meantime, like Phill said, there are many places you can add it. Like http://www.sql-scripts.com/ , http://www.planetsourcecode.com/ or many other.

There are also several French speaking newsgroups about SQL Server hosted by Microsoft. Here's the link to the webinterface http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.fr.sqlserver&cat=fr_FR_1495f8aa-233c-4216-b013-e3f5ab14e8f9&lang=fr&cr=FR

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Igor Nikiforov SSC Enthusiast Points: 128 More actions · Answer 8

Dear Frank Kalis,

thanks for your opinion and advice.

Please send me your opinion about my functions to Igor2004@sympatico.ca

With best personal regards, Igor.

Dear Phill Carter,

thanks for your opinion and advice.

Please send me your opinion about my functions to Igor2004@sympatico.ca

With best personal regards, Igor.

HoneyChi Ten Centuries Points: 1084 More actions · Answer 9

Bonjour, Igor : si votre but ultime est l'emploi, puis-je suggérer que vous allez à certains des sites Web de recherche d'emploi, comme Monster.com ? Je devine juste, mais j'ai vu que vous déclarez par votre peinture que vous êtes actuellement sans emploi. J'espère que c'est utile à vous et je vous souhaite le meilleur - Linda

Igor Nikiforov SSC Enthusiast Points: 128 More actions · Answer 10

Montréal, le 21 avril 2005

Madame Linda Carpenter

Objet: La lettre de remerciement.

Madame,

Tout d'abord j'aimerais vous remercier de la suggestion que vous avez porté à ma annonce.

Quand même je me permets à faire quelques remarques

a) je veux savoir « puis-je faire quelques choses utile ou non »,

donc’ j `ai écrit quelques fonctions et maintenant je les distribue

b) pourquoi écris-je : «Je cherche un emploi » à cause de trois raisons

qui sont les suivant

1) C`est vrai

2) Quand j`avais publié mes fonctions j`ai reçu une lettre de programmeur québécois.

« Si vous avez des besoins pour faire faire de la programmation en sous-contractence, je suis disponible »

C`était lui qui a cherché des commandes chez moi !

3) Un programmeur russe a posé une question : « Pouvez-vous donner moi quelques conseils, comment est-ce qu`on peut partir travailler à l`Amérique ou au Canada. »

Donc j`ai eu besoin dire que Canada n`est pas un paradis pour les programmeurs de Russie.

Je connaissais au sujet de monster.ca, jobboom.com et cetera avant de cinq année de ma arrivée au Canada. Selon mon avis chercher l`empois là-bas c`est inutile parce que mes CV vont tout droit dans la poubelle. Il faut avant tout que je crée mon propre nom.

J'aimerais savoir votre avis au sujet de mes fonctions.

En attendant votre réponse, veuillez agréer, Madame, l'expression de mes meilleurs sentiments.

Igor Nikiforov

Montréal (Québec)