Pad strings/concatenate columns to simulate data columns in ASP select box with SQL Server 2K

[lindawie]

Dale,

> Is there a simple function PADR() or something like that that I
> can use in ASP/VB Script to pad a string with spaces?
>
> The data I'm using sits in a SQL Server database, so if there
> isn't an easy way to do this in ASP, is there a simple T-SQL
> solution?

Cast all the data to fixed character data type in your select
statement.
For example:

select cast(au_id as char(12)) +
cast(au_fname as char(20)) +
cast(au_lname as char(20))
from pubs..authors


Linda