G
George Durzi
I have a stored procedure that is returning a column which is
cast(company_name as char(30)) + ' | ' + cast(client_name as char(20) + ' |
'
2by4 Brand Architects | Test, TEst |
3M Corporation | Diehl, Mary Ann |
3M Corporation | Kleinfeldt, Barbara |
(formatting above may be off), but the char datatype gives me the nice
spacing.
When I call this SP to create a dataset, and bind it to a drop down list,
all the extra spaces are gone, and the rows in the drop down list look like:
2by4 Brand Architects | Test, TEst |
3M Corporation | Diehl, Mary Ann |
3M Corporation | Kleinfeldt, Barbara |
How can I maintain that formatting ?
cast(company_name as char(30)) + ' | ' + cast(client_name as char(20) + ' |
'
2by4 Brand Architects | Test, TEst |
3M Corporation | Diehl, Mary Ann |
3M Corporation | Kleinfeldt, Barbara |
(formatting above may be off), but the char datatype gives me the nice
spacing.
When I call this SP to create a dataset, and bind it to a drop down list,
all the extra spaces are gone, and the rows in the drop down list look like:
2by4 Brand Architects | Test, TEst |
3M Corporation | Diehl, Mary Ann |
3M Corporation | Kleinfeldt, Barbara |
How can I maintain that formatting ?