Oracle and MySQL can deal with the RPAD- and LPAD-functions, but SQL Server cannot! Is there a similar function to do the same ??
What I want is a query with fixed sized columns.
for example:
[tt]
table TEST
----------
id int
name nvarchar 10
[/tt]
When querying this table I want the field name 15 characters long .. and filled with a trailing character "#".
like:
"DaHapMan#######"
Hope someone can help. thnx
DaHapMan
What I want is a query with fixed sized columns.
for example:
[tt]
table TEST
----------
id int
name nvarchar 10
[/tt]
When querying this table I want the field name 15 characters long .. and filled with a trailing character "#".
like:
"DaHapMan#######"
Hope someone can help. thnx
DaHapMan