A Question

25/11/2004 - 23:12 por Luis Felipe | Informe spam
Hi,

I need your help.

There are a Function in Oracle and Fox that is PADL or PadR, this add a
quantity of characters to the left or rigth, all depend which one you like,
the parameters in this function is a string, the character that user likes
to add (the normal are zeros and spaces), and the total size of string.
Someone know a Function equal or similar in SQl Server.

Thanks for all


Luis Felipe

Preguntas similare

Leer las respuestas

#1 MAXI
25/11/2004 - 23:45 | Informe spam
hi, in sql-server the function is REPLICATE

BYE




Maxi

Buenos Aires - Argentina
Desarrollador .NET 3 Estrellas
Microsoft User Group (MUG)
Mail: Maxi_accotto[arroba]speedy.com.ar

Msn Messenger:

"Luis Felipe" escribió en el mensaje
news:%
Hi,

I need your help.

There are a Function in Oracle and Fox that is PADL or PadR, this add a
quantity of characters to the left or rigth, all depend which one you
like,
the parameters in this function is a string, the character that user likes
to add (the normal are zeros and spaces), and the total size of string.
Someone know a Function equal or similar in SQl Server.

Thanks for all


Luis Felipe


Respuesta Responder a este mensaje
#2 Gustavo Larriera [MVP]
26/11/2004 - 02:13 | Informe spam
Hola Luis Felipe, por favor escribe en idioma español en este foro.

Luis Felipe wrote:
There are a Function in Oracle and Fox that is PADL or PadR, this
add a quantity of characters to the left or rigth, all depend which
one you like, the parameters in this function is a string, the
character that user likes to add (the normal are zeros and spaces),
and the total size of string. Someone know a Function equal or
similar in SQl Server.



busca en este mismo foro un hilo "Cadena de caracteres" iniciado por
María Eugenia Ryan donde se explicó cómo hacerlo.

Gustavo Larriera, MVP
Uruguay LatAm
http://sqljunkies.com/weblog/gux/
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.
email Siga el debate Respuesta Responder a este mensaje
Ads by Google
Help Hacer una preguntaRespuesta Tengo una respuesta
Search Busqueda sugerida