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


Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0