If you really want help you will need to post details about what you are trying to accomplish.  We aren't mind readers and we can't see what you are doing...

I got something like this to return all, including a rollup of all the non other entries:

declare @jobdata table
 (rundate datetime,
 jobnbr varchar(8),
 tasknbr VARCHAR(3),
 jobstatus...

Another option:

SELECT
  Account
  ,LEN(Account)
  ,STUFF(STUFF(ISNULL(STUFF(Account,14,0,'-'),Account),10,0,'-'),6,0,'-')
FROM (VALUES
('1234512341234')
,('1234512341234123')
,('12345123412341234')
,('123451234123412345')
,('1234512341234123456')
)dt(Account);


Like this:

SELECT
  Account
  ,LEN(Account)
  ,STUFF(STUFF(CASE WHEN LEN(Account) >= 14 THEN STUFF(Account,14,0,'-') ELSE Account END,10,0,'-'),6,0,'-')
FROM (VALUES
('1234512341234')
,('1234512341234123')
,('12345123412341234')
,('123451234123412345')
,('1234512341234123456')
)dt(Account);


Here are some routines: http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

Okay, so the [?]...