Les fonctions T-SQL pour le traitement des strings
2 réponses
Igor2004
Les fonctions T-SQL pour le traitement des chaînes de caractères
Mesdames et Messieurs,
Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les
suivants
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 (include overlaps)
OCCURS2() Returns the number of times a character expression occurs within
another character expression (exclude 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
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
STRTRAN() Searches a character expression for occurrences of a second
character expression, and then replaces each
occurrence with a third character expression.
(in difference from a built-in function replace, STRTRAN has
three additional parameters)
STRFILTER() Removes all characters from a string except those specified
GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
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 sont semblables aux fonctions Oracle PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP
Plus de 4000 personnes ont déjà téléchargé ces fonctions. Qui sait,
peut-être seront-ils utiles pour vous ?
Pour plus d`information, veuillez visiter
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Veuillez télécharger le fichier
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs
sentiments.
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
TLE91
C'est un forum d'entreaide ... Pas un forum de publicité !!!
"Igor2004" a écrit :
Les fonctions T-SQL pour le traitement des chaînes de caractères Mesdames et Messieurs,
Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les suivants
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 (include overlaps) OCCURS2() Returns the number of times a character expression occurs within another character expression (exclude 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 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 STRTRAN() Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. (in difference from a built-in function replace, STRTRAN has three additional parameters) STRFILTER() Removes all characters from a string except those specified GETWORDCOUNT() Counts the words in a string GETWORDNUM() Returns a specified word from a string 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 sont semblables aux fonctions Oracle PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP
Plus de 4000 personnes ont déjà téléchargé ces fonctions. Qui sait, peut-être seront-ils utiles pour vous ?
Pour plus d`information, veuillez visiter http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Veuillez télécharger le fichier http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs sentiments.
C'est un forum d'entreaide ... Pas un forum de publicité !!!
"Igor2004" a écrit :
Les fonctions T-SQL pour le traitement des chaînes de caractères
Mesdames et Messieurs,
Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les
suivants
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 (include overlaps)
OCCURS2() Returns the number of times a character expression occurs within
another character expression (exclude 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
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
STRTRAN() Searches a character expression for occurrences of a second
character expression, and then replaces each
occurrence with a third character expression.
(in difference from a built-in function replace, STRTRAN has
three additional parameters)
STRFILTER() Removes all characters from a string except those specified
GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
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 sont semblables aux fonctions Oracle PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP
Plus de 4000 personnes ont déjà téléchargé ces fonctions. Qui sait,
peut-être seront-ils utiles pour vous ?
Pour plus d`information, veuillez visiter
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Veuillez télécharger le fichier
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs
sentiments.
C'est un forum d'entreaide ... Pas un forum de publicité !!!
"Igor2004" a écrit :
Les fonctions T-SQL pour le traitement des chaînes de caractères Mesdames et Messieurs,
Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les suivants
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 (include overlaps) OCCURS2() Returns the number of times a character expression occurs within another character expression (exclude 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 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 STRTRAN() Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. (in difference from a built-in function replace, STRTRAN has three additional parameters) STRFILTER() Removes all characters from a string except those specified GETWORDCOUNT() Counts the words in a string GETWORDNUM() Returns a specified word from a string 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 sont semblables aux fonctions Oracle PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP
Plus de 4000 personnes ont déjà téléchargé ces fonctions. Qui sait, peut-être seront-ils utiles pour vous ?
Pour plus d`information, veuillez visiter http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Veuillez télécharger le fichier http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs sentiments.
Igor2004
Mes fonctions sont gratuites, donc, ce n’est pas la publicité. Pensez-vous qu’ils ne peuvent pas résoudre quelques problèmes et qu’ils ne peuvent pas aider à quelque’un en fonctionnant sans erreurs conformément à ses spécifications ? Vous n’avez qu’à cliquer sur http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
"TLE91" wrote:
C'est un forum d'entreaide ... Pas un forum de publicité !!!
"Igor2004" a écrit :
> Les fonctions T-SQL pour le traitement des chaînes de caractères > Mesdames et Messieurs, > > Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les > suivants > > 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 (include overlaps) > OCCURS2() Returns the number of times a character expression occurs within > another character expression (exclude 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 > 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 > STRTRAN() Searches a character expression for occurrences of a second > character expression, and then replaces each > occurrence with a third character expression. > (in difference from a built-in function replace, STRTRAN has > three additional parameters) > STRFILTER() Removes all characters from a string except those specified > GETWORDCOUNT() Counts the words in a string > GETWORDNUM() Returns a specified word from a string > 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 sont semblables aux fonctions Oracle PL/SQL > INSTR, LPAD, RPAD, TRANSLATE, INITCAP > > Plus de 4000 personnes ont déjà téléchargé ces fonctions. Qui sait, > peut-être seront-ils utiles pour vous ? > > Pour plus d`information, veuillez visiter > http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 > > Veuillez télécharger le fichier > http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 > > Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs > sentiments.
Mes fonctions sont gratuites, donc, ce n’est pas la publicité.
Pensez-vous qu’ils ne peuvent pas résoudre quelques problèmes et
qu’ils ne peuvent pas aider à quelque’un en fonctionnant sans erreurs
conformément à ses spécifications ?
Vous n’avez qu’à cliquer sur
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
"TLE91" wrote:
C'est un forum d'entreaide ... Pas un forum de publicité !!!
"Igor2004" a écrit :
> Les fonctions T-SQL pour le traitement des chaînes de caractères
> Mesdames et Messieurs,
>
> Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les
> suivants
>
> 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 (include overlaps)
> OCCURS2() Returns the number of times a character expression occurs within
> another character expression (exclude 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
> 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
> STRTRAN() Searches a character expression for occurrences of a second
> character expression, and then replaces each
> occurrence with a third character expression.
> (in difference from a built-in function replace, STRTRAN has
> three additional parameters)
> STRFILTER() Removes all characters from a string except those specified
> GETWORDCOUNT() Counts the words in a string
> GETWORDNUM() Returns a specified word from a string
> 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 sont semblables aux fonctions Oracle PL/SQL
> INSTR, LPAD, RPAD, TRANSLATE, INITCAP
>
> Plus de 4000 personnes ont déjà téléchargé ces fonctions. Qui sait,
> peut-être seront-ils utiles pour vous ?
>
> Pour plus d`information, veuillez visiter
> http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
>
> Veuillez télécharger le fichier
> http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
>
> Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs
> sentiments.
Mes fonctions sont gratuites, donc, ce n’est pas la publicité. Pensez-vous qu’ils ne peuvent pas résoudre quelques problèmes et qu’ils ne peuvent pas aider à quelque’un en fonctionnant sans erreurs conformément à ses spécifications ? Vous n’avez qu’à cliquer sur http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
"TLE91" wrote:
C'est un forum d'entreaide ... Pas un forum de publicité !!!
"Igor2004" a écrit :
> Les fonctions T-SQL pour le traitement des chaînes de caractères > Mesdames et Messieurs, > > Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les > suivants > > 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 (include overlaps) > OCCURS2() Returns the number of times a character expression occurs within > another character expression (exclude 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 > 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 > STRTRAN() Searches a character expression for occurrences of a second > character expression, and then replaces each > occurrence with a third character expression. > (in difference from a built-in function replace, STRTRAN has > three additional parameters) > STRFILTER() Removes all characters from a string except those specified > GETWORDCOUNT() Counts the words in a string > GETWORDNUM() Returns a specified word from a string > 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 sont semblables aux fonctions Oracle PL/SQL > INSTR, LPAD, RPAD, TRANSLATE, INITCAP > > Plus de 4000 personnes ont déjà téléchargé ces fonctions. Qui sait, > peut-être seront-ils utiles pour vous ? > > Pour plus d`information, veuillez visiter > http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 > > Veuillez télécharger le fichier > http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 > > Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs > sentiments.
