User-Defined Funciones de la Secuencia Transact-SQL

Señoras y Señores

Quisiera poner a su alcance las funciones de Transact-SQL que vienen a
continuación
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
CHRTRAN() Replaces each character in a character expression that matches
a
character in a second character expression with the corresponding
character
in a third character expression
STRFILTER() Removes all characters from a string except those specified
OCCURS() Returns the number of times a character expression occurs within
another character expression (include overlaps)
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
ARABTOROMAN() Returns the character Roman number equivalent of a specified
numeric expression (from 1 to 3999)
ROMANTOARAB() Returns the number equivalent of a specified character Roman
number expression (from I to MMMCMXCIX)

AT, PADL, PADR, CHRTRAN, PROPER are similar to functions Oracle PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP

More than 2000 people have already downloaded my functions. I hope you
will
find it useful as well.

For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wcon...velExtreme~2,54,33,27115
Por favor tome el archivo
http://www.universalthread.com/wcon...velExtreme~2,2,27115

Quisiera agradecerles a Ustedes toda vuestra atención y mis mejores
sentimientos.

Gracias Igor, son de gran utilidad esas funciones.

Muchísimos saludos
~gux

Gustavo Larriera
Uruguay LatAm
Blog: http://sqljunkies.com/weblog/gux/
MVP profile: http://aspnet2.com/mvp.ashx?GustavoLarriera
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and confers
no rights.

"Igor2004" wrote in message
news:

Señoras y Señores

Quisiera poner a su alcance las funciones de Transact-SQL que vienen a
continuación
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
CHRTRAN() Replaces each character in a character expression that
matches a
character in a second character expression with the corresponding
character
in a third character expression
STRFILTER() Removes all characters from a string except those specified
OCCURS() Returns the number of times a character expression occurs within
another character expression (include overlaps)
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
ARABTOROMAN() Returns the character Roman number equivalent of a
specified
numeric expression (from 1 to 3999)
ROMANTOARAB() Returns the number equivalent of a specified character
Roman
number expression (from I to MMMCMXCIX)

AT, PADL, PADR, CHRTRAN, PROPER are similar to functions Oracle PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP

More than 2000 people have already downloaded my functions. I hope you
will
find it useful as well.

For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wcon...velExtreme~2,54,33,27115
Por favor tome el archivo
http://www.universalthread.com/wcon...velExtreme~2,2,27115

Quisiera agradecerles a Ustedes toda vuestra atención y mis mejores
sentimientos.

Gracias Igor, son de gran utilidad esas funciones.

Muchísimos saludos
~gux

Gustavo Larriera
Uruguay LatAm
Blog: http://sqljunkies.com/weblog/gux/
MVP profile: http://aspnet2.com/mvp.ashx?GustavoLarriera
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and confers
no rights.

"Igor2004" wrote in message
news:
> Señoras y Señores
>
> Quisiera poner a su alcance las funciones de Transact-SQL que vienen a
> continuación
> 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
> CHRTRAN() Replaces each character in a character expression that matches
> a
> character in a second character expression with the corresponding
> character
> in a third character expression
> STRFILTER() Removes all characters from a string except those specified
> OCCURS() Returns the number of times a character expression occurs within
> another character expression (include overlaps)
> 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
> ARABTOROMAN() Returns the character Roman number equivalent of a specified
> numeric expression (from 1 to 3999)
> ROMANTOARAB() Returns the number equivalent of a specified character Roman
> number expression (from I to MMMCMXCIX)
>
> AT, PADL, PADR, CHRTRAN, PROPER are similar to functions Oracle PL/SQL
> INSTR, LPAD, RPAD, TRANSLATE, INITCAP
>
> More than 2000 people have already downloaded my functions. I hope you
> will
> find it useful as well.
>
> For more information about string UDFs Transact-SQL please visit the
> http://www.universalthread.com/wcon...velExtreme~2,54,33,27115
> Por favor tome el archivo
> http://www.universalthread.com/wcon...velExtreme~2,2,27115
>
> Quisiera agradecerles a Ustedes toda vuestra atención y mis mejores
> sentimientos.
>