Printer Commands from Stored Procs

[itsmarkdavies]

I am building a Table from a Stored Procedure as follows :-

insert into WEB..PF_Manifest(TEXT) select ' '
insert into WEB..PF_Manifest(TEXT) select 'Number of Consignments ' + CONVERT(VARCHAR(50), @CONSIGNCOUNT)

I need to be able to send a "New Page" command at certain points in the file to focre the printer to go to a new page before printing the next line of text.

I am then going to either send this as a file using xp_sendmail to be printed manually (in which case I need to embed the "New Page" commands in the file, or send it directly to a Printer including the "New Page" commands.

I have tried including :-

insert into WEB..PF_Manifest(TEXT) select CHAR(12)

OR

insert into WEB..PF_Manifest(TEXT) select '^' + CHAR(13)

but these do not seem to work. Any pointers greatly appreciated. Thanks.