name width start end
unique id 10 1 10
Indicator 1 11 11
title 4 12 15
first name 30 16 45
mid initial 1 46 46
last name 35 47 81
...and so on.
Here is my query
select personid,companyid='I',perprefix,perfname,left(permname,1),perlname,addrline1+' '+addrline2,city,state,left(zip,5),country = 'USA'
from peopleroleup
where country ='United States'
and companyid is null
How do I pad this out? I am using SQL2k Query Analyzer.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
