| Subject | how to get the same length result |
|---|---|
| Author | Yang Jin |
| Post date | 2005-10-04T14:11:28Z |
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
---------------------------------
雅虎免费G邮箱－中国第一绝无垃圾邮件骚扰超大邮箱
雅虎助手－搜索、杀毒、防骚扰
[Non-text portions of this message have been removed]
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
---------------------------------
雅虎免费G邮箱－中国第一绝无垃圾邮件骚扰超大邮箱
雅虎助手－搜索、杀毒、防骚扰
[Non-text portions of this message have been removed]