Thank Ivan's reply and thank you Ali also.
I find the lpad function in udf.
It need three params.one is the source string;
second is the result length; third is the default string to fill the blank.for example, lpad('abc', 5, '3') = 'eeabc'.
Thanks again.



Jinyang

Regrads.


.com> 写道：
Yang Jin wrote:

>hello,
> I want to get the same length varchar filed in table from procedure.The content of field is '1', '12 and '123';I want to get ' 1', ' 12' and '123'.I use cast(XX as varchar(3)), but result is dispoint.
> Who can tell me a useful method, TIA!
>
>jinyang
>regard
>
>
>

Firebird 1.5 nows ships with a version of ib_udf that includes
a "lpad" function. That function is exactly what you are
looking for. Take a look in the release notes for details.

Ivan.



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS
Technical support Computer technical support Compaq computer technical support Compaq technical support Hewlett packard technical support Microsoft technical support

---------------------------------
YAHOO! GROUPS LINKS


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------




---------------------------------
雅虎免费G邮箱－中国第一绝无垃圾邮件骚扰超大邮箱
雅虎助手－搜索、杀毒、防骚扰

[Non-text portions of this message have been removed]