Hi
Use the sql below and then create view or use command object
select
empid,
surname,
sin ,
--the below code adds leading zeros depending on length of the field
stuff(empid, 1, 0, replicate('0', 8 - len(empid)))+surname as 'Empid-Surname',
-- starts the sin from 29th position
stuff(sin, 1, 0, replicate(' ', 29 - len(sin))) as 'Sin',
---final result
stuff(empid, 1, 0, replicate('0', 8 - len(empid)))+surname+
stuff(sin, 1, 0, replicate(' ', 29 - len(stuff(empid, 1, 0, replicate('0', 8 - len(empid)))+surname)))AS Result
from Table_Emp
the final result is not formatted correctly due to lenght of values in surname field ......hope you can work on it..........
cheers
Rahul
IP Logged
