Subject |
fixed with string |
From |
Mustansir Ghor <mustan31@hotmail.com> |
Date |
Fri, 23 Feb 2018 15:37:54 -0500 |
Newsgroups |
dbase.getting-started |
Dear All
In the below statement how to make r.name to display fixed width string.
select r.rno||', '||cast(r.name as char(25))||' - '||cast(r.unit as char(20)) as pname from ipdreg r
Regards
Mustansir
|
|