Ailsom,
Unfortunately there isnt't a prebuilt function , but for numeric quantities
you can use:
SELECT REPLICATE('0', (10 - LEN(CAST(Quantity, VARCHAR)))) + CAST(Quantity,
VARCHAR) AS PaddedQuantity
FROM <Table>
Snd if Qty is already a string then:
SELECT REPLICATE('0', (10 - LEN(Quantity))) + Quantity AS PaddedQuantity
FROM <Table>
To define a Padr() and Padl() UDF look at:
http://www.developerdotstar.com/community/node/319
Dave Crozier
The secret to staying young is to live honestly, eat slowly, and to lie
about your age
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ailsom F. Heringer (Osklen)
Sent: 05 September 2006 15:13
To: ProFox Email List
Subject: SQLServer: PADL ???
Is there any SQLServer (T-SQL) equivalent for VFP PADL() ??
--
Aílsom F. Heringer
[EMAIL PROTECTED]
Skype: ailsom.osklen
Analista de Sistemas
----------------------------------
Osklen
Departamento de Informática
Rio de Janeiro - RJ
BRASIL
http://www.osklen.com.br
55 21 22198971
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
